| 
Memory Management Mode | 
For | 
You Set | 
Oracle Database Automatically Tunes | 
| 
Automatic memory management (AMM) | 
SGA and PGA | 
 | 
 | 
| 
Automatic shared memory management (ASMM) (AMM disabled) | 
SGA | 
 | 
SGA component sizes | 
| 
Manual shared memory management (AMM and ASMM disabled) | 
SGA | 
 | 
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 | 
Thursday, April 11, 2013
Various memory management methods:
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment