Best Practices for Database Memory (PGA) Settings
(Doc ID 3076767.1)
Last updated on MARCH 21, 2025
Applies to:
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and laterGen 2 Exadata Cloud at Customer - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.2.0.0 and later
Information in this document applies to any platform.
Purpose
This note provides you some guidance for database PGA memory configuration is order to reduce (memory) related errors and improve database performance.
The suggestions made here are based on the Development team's recommendations, on the ORA-4030/ORA-4036 causes and solutions and the Oracle documentation. It may not solve all the problems, as issues might occur from various other causes that we cannot predict, in which case you will need to open a service request with Oracle Support.
Here is a list of errors that might be avoided after using these recommendations:
Scope
This article applies to all Oracle databases.
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 |
| References |