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