ASMM and AUM

Oracle 9i ** Oracle 10g** Oracle 11g**
SGA SGA + PGA
DB_CACHE_SIZE SGA_TARGET *** MEMORY_TARGET
SHARED_POOL_SIZE
LARGE_POOL_SIZE
JAVA_POOL_SIZE
PGA
PGA_AGGREGATE_TARGET PGA_AGGREGATE_TARGET

 

** :  Space can be allocated for all memory areas even if automatic option is enabled. The set values act  as minimum threshold.

***: Space must be manually allocated for the following memory areas

  1. LOG_BUFFER
  2. DB_nk_CACHE_SIZE (Where n  is 2,4,6,8,16,32)
  3. DB_RECYCLE_CACHE_SIZE
Advertisements
%d bloggers like this: