Help - Search - Members - Calendar
Full Version: sga_max_size limitation 11g 64bit windows
Oracle DBA Forums > Oracle > Oracle Forum
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.
Hi Troy,

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

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:
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-2015 Invision Power Services, Inc.