ORA-4030 Occurs When Running a Spatial Point Statement and Supplemental Logging is Enabled (Doc ID 2223556.1)

Last updated on FEBRUARY 01, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

ORA-4030 occurs when running a Spatial update that defines point data and supplemental logging is enabled.

example:

UPDATE cc_address SET SPATIALPOINT = SDO_GEOMETRY(2001, 4326, SDO_POINT_TYPE(longitude, latitude, NULL), NULL, NULL) WHERE cc_address.LONGITUDE IS NOT NULL

ORA-04030: out of process memory when trying to allocate 4024 bytes (qmxlu subheap,buff_kghscl)

TOP 10 MEMORY USES FOR THIS PROCESS
---------------------------------------

*** 2017-01-15 07:32:29.205
47% 14 GB, 5629344 chunks: "permanent memory "
qmxtgCrBufClWL ds=0x7fe5175aa728 dsprt=0x7fed04157810
38% 12 GB, 5630516 chunks: "permanent memory "
qmxlu subheap ds=0x7fe5175a7528 dsprt=0x7fe5175ac998
4% 1354 MB, 1877307 chunks: "free memory "
qmxlu subheap ds=0x7fe5175ab958 dsprt=0x7fe5175aca38
3% 894 MB, 3752896 chunks: "permanent memory "
qmxtgGetXobd:p ds=0x7fe5175ac998 dsprt=0x7fecfdefbf58
2% 687 MB, 3752896 chunks: "qmxtgCrBufClWL "
koh dur heap d ds=0x7fed04157810 dsprt=0x7fed04c7cf60
1% 346 MB, 22208 chunks: "qmxtgAllocAndSetXLob "
koh-kghu sessi ds=0x7fecfe4e8fe8 dsprt=0x7fed04c7cf60
1% 292 MB, 3752898 chunks: "kolraloc-1 "
kolr heap ds i ds=0x7fed04c985b8 dsprt=0x7fed04c7cf60
1% 286 MB, 1876448 chunks: "qmxtgGetXobd:parent_heap1 "
koh dur heap d ds=0x7fecfdefbf58 dsprt=0x7fed04c7cf60
1% 229 MB, 3752896 chunks: "kolrarfc:lobloc_kolrhte "
kolr heap ds i ds=0x7fed04c985b8 dsprt=0x7fed04c7cf60
1% 167 MB, 10489 chunks: "kolrde_alloc "
koh-kghu sessi ds=0x7fed04caf660 dsprt=0x7fed04c7cf60

 

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