How to configure ASMM (Auto Memory) on 10g and 11g - Best Practices
(Doc ID 781630.1)
Last updated on JULY 25, 2019
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
The goal of this note is to assist with the setup and configuration of ASMM using best practices to avoid potential future memory problems. Specifically large KGH: NO ACCESS in 10g and small pools/incorrectly set pools in 11G. ORA-4031 errors are the result of both situations and can be hard to track down.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document