How to configure ASMM (Auto Memory) on 10g and 11g - Best Practices
Last updated on MARCH 07, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms