Sizing the PGA in Oracle 19c - How to Account for the MGA Size
(Doc ID 2808761.1)
Last updated on JULY 01, 2022
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
In Oracle 19c and up, the MGA (Managed Global Area) is accounted for out of the PGA. Therefore it follows that when upgrading from an earlier version, the maximum allowable PGA size (PGA_AGGREGATE_LIMIT) must be increased to account for the MGA. See the following note for a detailed description of the MGA and its functions:
MGA (Managed Global Area) Reference Note (<Document 2638904.1>)
But how much should PGA_AGGREGATE_LIMIT be increased to account for the MGA?
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