My Oracle Support Banner

How to configure ASMM (Auto Memory) on 10g and 11g - Best Practices (Doc ID 781630.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.