Oracle Memory 101
1. SGA consists of
a. Buffer Pool: DB_BLOCK_BUFFERS (unit: Blocks) or DB_CACHE_SIZE when you use the dynamic SGA.
b. Shared Pool: SHARED_POOL_SIZE ( refer SAPnote 618868/690241)
c. Java Pool: JAVA_POOL_SIZE.
e. Large Pool: LARGE_POOL_SIZE.
f. Redo Buffer: LOG_BUFFER
2. The PGA allocation is dynamic and can be affected by the parameters SORT_AREA_SIZE, HASH_AREA_SIZE,
BITMAP_MERGE_AREA_SIZE and CREATE_BITMAP_AREA_SIZE or PGA_AGGREGATE_TARGET when you use the automatic PGA administration
3. V$DB_CACHE_ADVICE – size advisor
4. SGA_MAX_SIZE – dynamic SGA. Key SGA components can be altered dynamically – buffer cache, shared pool and large pool.
Advertisement
