My Oracle Support Banner

Automatic Memory Management (AMM) on 11g & 12c (Doc ID 443746.1)

Last updated on APRIL 06, 2020

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Purpose

The main goal of this document is to discuss Automatic Memory Management (AMM) features introduced with Oracle11g and how to enable it.

Note:
If you would like to explore this topic further, please join the Community discussion 'Using ASSM on Oracle 10g and 11g and AMM on Oracle 11g' where you can ask questions, get help from others, and share your experiences with this specific article.

Scope

All the DBAs and users concerned with Database Administration activities.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Introduction to Database Memory Components
 Evolution of Memory Management Features
 1. Automatic Memory Management – For Both the SGA and Instance PGA
 Switching to Automatic Memory Management
 Monitoring and Tuning Automatic Memory Management
 11g MEMORY_TARGET Parameter Dependency
 2. Automatic Shared Memory Management – For the SGA
 3. Manual Shared Memory Management – For the SGA
 4. Automatic PGA Memory Management – For the Instance PGA
 5. Manual PGA Memory Management – For the Instance PGA
 6. AMM impact on Solaris OS
 7. Automatic PGA memory management limitations on Linux
 Community discussion
References

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