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

(Doc ID 781630.1)

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.

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