Embedded Files
Oracle Automatic Memory Managment
*** DO NOT USE THIS FEATURE ***
This video by Mike Dietrich from the Oracle Database Upgrades and Migrations YouTube channel explains why...
Also, AMM is not compatible with Linux HugePages.
Use ASMM and APMM instead.
A MEMORY_TARGET of 0 disables Automatic Memory Management.
Parameters
Parameters
MEMORY_TARGET
Should always be 0 (see above)MEMORY_TARGET
MEMORY_MAX_TARGET
Should always be 0 (see above)MEMORY_MAX_TARGET
Check
Check
SHOW PARAMETER MEMORY_TARGET
SHOW SPPARAMETER MEMORY_TARGET
Check
Check
SHOW PARAMETER MEMORY_MAX_TARGET
SHOW SPPARAMETER MEMORY_MAX_TARGET
Change
Change
ALTER SYSTEM SET MEMORY_TARGET='0' SCOPE=spfile;
Restart the databaseOrÂ
only if MEMORY_MAX_TARGET is set at a higher value than MEMORY_TARGET...ALTER SYSTEM SET MEMORY_TARGET='0' SCOPE=memory;
ALTER SYSTEM SET MEMORY_TARGET='0' SCOPE=both;
Change
Change
ALTER SYSTEM SET MEMORY_MAX_TARGET='0' SCOPE=spfile;
Restart the databaseBibliography
Bibliography
Page updated
Google Sites
Report abuse