Oracle has improvised the memory management in all the versions from 9i. We have pga_aggregate_target parameter to govern the programable global area management. The same automation in memory allocation is enforced in sga from 10g. But in oracle 11g this goes even better that is AMM, which oracle uses to dynamically allocate memory between PGA and SGA.
The 2 parameters that rule the AMM are MEMORY_MAX_TARGET and MEMORY_TARGET. Memory_max_target is static parameter and memory_max_target is dynamic. Any non zero value for memory_target will enable the AMM feature. This feature is very much helpful for OLTP environments running with share server configuration.
The 2 parameters that rule the AMM are MEMORY_MAX_TARGET and MEMORY_TARGET. Memory_max_target is static parameter and memory_max_target is dynamic. Any non zero value for memory_target will enable the AMM feature. This feature is very much helpful for OLTP environments running with share server configuration.
