Thursday, April 11, 2013

Various memory management methods:

Memory Management Mode
For
You Set
Oracle Database Automatically Tunes
Automatic memory management (AMM)
SGA and PGA
  • Total memory target size for the Oracle instance (MEMORY_TARGET)
  • (Optional) Maximum memory size for the Oracle instance (MEMORY_MAX_TARGET)
  • Total SGA size
  • SGA component sizes
  • Instance PGA size
  • Individual PGA sizes
Automatic shared memory management (ASMM)
(AMM disabled)
SGA
  • SGA target size (SGA_TARGET)
  • (Optional) SGA maximum size (SGA_MAX_SIZE)
SGA component sizes
Manual shared memory management
(AMM and ASMM disabled)
SGA
  • Shared pool size (SHARED_POOL_SIZE)
  • Buffer cache size (DB_CACHE_SIZE or DB_BLOCK_BUFFERS)
  • Java pool size (JAVA_POOL_SIZE)
  • Large pool size (LARGE_POOL_SIZE)
  • (Optional) SGA maximum size (SGA_MAX_SIZE)
None
Automatic PGA memory management
PGA
Instance PGA target size (PGA_AGGREGATE_TARGET)
Individual PGA sizes
Manual PGA memory management
(Not recommended)
PGA
Maximum work area size for each type of SQL operator
None

No comments:

Post a Comment