Help - Search - Members - Calendar
Full Version: sga_max_size limitation 11g 64bit windows
Oracle DBA Forums > Oracle > Oracle Forum
troy
Using AMM in 11g I noticed that regardless of how much the memory target is set to
oracle sets the sga_max_size to 2.4G when I bounce the db. I can't find any documentation telling me
what oracle is doing or if there is a way around this. OS is windows 2003 64bit.
burleson
Hi Troy,

First, beware, as AMM still has bugs in 11g. I don't use it:

http://www.dba-oracle.com/t_amm_automatic_memory_resize.htm

The sga_max_size sets the hard limit up to which sga_target can dynamically adjust sizes.

Usually, sga_max_size and sga_target will be the same value, but there may be times when you want to have the capability to adjust for peak loads. By setting this parameter higher than sga_target, you allow dynamic adjustment of the sga_target parameter.

Dr Hall has some good notes on the 11gAMM features:

http://www.oracle-base.com/articles/11g/Au...ement_11gR1.php
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.