My Oracle Support Banner

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 19.0.0.0 and later
Information in this document applies to any platform.

Goal

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?

Solution

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
Goal
Solution
References


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