Automatic Memory Management (AMM) on 11g & Above
(Doc ID 443746.1)
Last updated on NOVEMBER 13, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.6 and laterGen 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.
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 |