ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT on SDO_AGGR_UNION

(Doc ID 2381928.1)

Last updated on APRIL 05, 2018

Applies to:

Oracle Spatial and Graph - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

During the processing of spatial data in a PL/SQL program, the session was terminated with
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

The default value for PGA_AGGREGATE_LIMIT of 6000 MB was used during the first run of the program, then was increased to 10 GB, 20 GB , 30 GB and finally to 100 GB.
The execution of the coverage load with a PGA_AGGREGATE_LIMIT of 100 GB was terminated with the following error stack:

ORA-06512: in "MDSYS.AGGRUNION", Zeile 30
ORA-06512: in "GIS_ORACLE.DATALOAD_COV_HANDLE_AV_OBJECT", Zeile 910
ORA-04030: Zu wenig Prozessspeicher fuer Versuch 16328 Byte zuzuweisen (koh-kghu sessi,kolcalm coll)
ORA-04030: Zu wenig Prozessspeicher fuer Versuch 16328 Byte zuzuweisen (koh-kghu sessi,pmucalm coll)
ORA-04030: Zu wenig Prozessspeicher fuer Versuch 16328 Byte zuzuweisen (koh-kghu sessi,pmucalm coll)

On another attempt the program was started with pga_aggregate_limit of 75 GB. The execution was terminated with message

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

ERROR at line 4:
ORA-03113: Unerwartetes uebertragungsende in Kommunikation
Prozess-ID: 8393
Session-ID: 192 Seriennummer: 5040

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms