My Oracle Support Banner

ORA-04030: out of process memory when trying to allocate 32792 bytes (pga heap,MDGORDADT: Segmented Coordinate Array) (Doc ID 1583018.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

Spatial query logs errors in the alert.log

SELECT col1, col2, ..., col5
FROM table
WHERE ((MDSYS.SDO_RELATE(GEOMETRY,MDSYS.SDO_GEOMETRY(2003,8307,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-1.7063190695781E7,-6545455.605205,1.7063190695781E7,6545455.605205)),'mask = ANYINTERACT')='TRUE'));

 

Incident 561679 created, dump file: /oracle/oradata/diag/rdbms/cswora1/MYDB/incident/incdir_561679/MYDB_ora_31356_i561679.trc
ORA-04030: out of process memory when trying to allocate 32792 bytes (pga heap,MDGORDADT: Segmented Coordinate Array)

Incident 561680 created, dump file: /oracle/oradata/diag/rdbms/cswora1/MYDB/incident/incdir_561680/MYDB_ora_31356_i561680.trc
ORA-04030: out of process memory when trying to allocate 169040 bytes (pga heap,kgh stack)
ORA-04030: out of process memory when trying to allocate 32792 bytes (pga heap,MDGORDADT: Segmented Coordinate Array)

Incident 561681 created, dump file: /oracle/oradata/diag/rdbms/cswora1/MYDB/incident/incdir_561681/MYDB_ora_31356_i561681.trc
ORA-04030: out of process memory when trying to allocate 82456 bytes (pga heap,control file i/o buffer)
ORA-04030: out of process memory when trying to allocate 32792 bytes (pga heap,MDGORDADT: Segmented Coordinate Array)

Cause

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
Symptoms
Cause
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.