ORA-4030 Occurs When Running a Spatial Point Statement and Supplemental Logging is Enabled
(Doc ID 2223556.1)
Last updated on FEBRUARY 11, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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 <table_name> SET SPATIALPOINT = SDO_GEOMETRY(2001, 4326, SDO_POINT_TYPE(longitude, latitude, NULL), NULL, NULL) WHERE <table_name>.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
Changes
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 |
Changes |
Cause |
Solution |
References |