How to configure ASMM (Auto Memory) on 10g and 11g - Best Practices
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
***Checked for relevance 17-Aug-2014***
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms