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

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***

Goal

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.

Solution

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