My Oracle Support Banner

Automatic Memory Management (AMM) SGA and PGA Management in 11g and Above (Doc ID 1392549.1)

Last updated on SEPTEMBER 18, 2024

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Purpose

The purpose of this document is to demonstrate how Automatic Memory Management (AMM) manages memory in the SGA and PGA.

Scope

The intended audience of this document is experienced Database Administrators and Oracle Support engineers interested in Automatic Memory Management.

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
 Mandatory parameters for AMM
 Optional parameters for AMM
 How to control the memory under MEMORY_TARGET?
 Give MMAN complete control
 Take control of memory yourself
 AMM details
 CASE 1: Only MEMORY_TARGET is set
 CASE 2: MEMORY_TARGET, SGA_TARGET and PGA_AGGREGATE_TARGET are set
 CASE 3: MEMORY_TARGET, SGA_MAX_SIZE, SGA_TARGET and PGA_AGGREGATE_TARGET are set
 Summary of case studies
 ORA-4030 and ORA-4031

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