Database Error Messages

ORA-04036

PGA memory used by the instance or PDB exceeds PGA_AGGREGATE_LIMIT.

Cause

Private memory across the instance or pluggable database (PDB) exceeded the limit specified in the PGA_AGGREGATE_LIMIT parameter. If the limit was reached when allocating from private memory used by more than one Oracle process (MGA or DGA), that process was interrupted. Otherwise, the largest sessions using Program Global Area (PGA) memory were interrupted to get under the limit.


Action

Increase the PGA_AGGREGATE_LIMIT initialization parameter or reduce memory usage.