Create Table Statement Fails with ORA-4030 (qmxlu Subheap,qmemNextBuf:rel Alloc)
(Doc ID 2095124.1)
Last updated on MARCH 11, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]Information in this document applies to any platform.
Symptoms
On 12.1.0.2, a create table statement fails with the following error:
ORA-04030: out of process memory when trying to allocate 1080 bytes (qmxlu subheap,qmemNextBuf:rel alloc)
The trace file shows something similar to the following:
=======================================
TOP 10 MEMORY USES FOR THIS PROCESS
----------------------------------------------------------------------
*** 2015-11-04 13:43:27.488
45% 14 GB, 3760982 chunks: "kghsseg: kolasl "
qmxtgCrBufClWL ds=0x2b4d4e885bf0 dsprt=0x2b45552aa080
17% 5419 MB, 1880496 chunks: "free permanent memory "
qmxlu subheap ds=0x2b4d4e882918 dsprt=0x2b4d4e8839e8
11% 3644 MB, 3760982 chunks: "qmemNextBuf:all "
qmxlu subheap ds=0x2b4d4e87a4d8 dsprt=0x2b4d4e883948
6% 1836 MB, 1880490 chunks: "qmemNextBuf:rel "
qmxlu subheap ds=0x2b4d4e882918 dsprt=0x2b4d4e8839e8
5% 1638 MB, 1854338 chunks: "free memory "
qmxlu subheap ds=0x2b4d4e87a4d8 dsprt=0x2b4d4e883948
2% 689 MB, 3760982 chunks: "qmxtgCrBufClWL "
koh dur heap d ds=0x2b45552aa080 dsprt=0x2b4554c0cf60
2% 646 MB, 1880491 chunks: "qmxlu P alloc "
qmxtgGetXobd:p ds=0x2b4d4e883948 dsprt=0x2b45552ca080
1% 347 MB, 22256 chunks: "qmxtgAllocAndSetXLob "
koh-kghu sessi ds=0x2b4555246468 dsprt=0x2b4554c0cf60
1% 344 MB, 5641473 chunks: "permanent memory "
qmxtgCrBufClWL ds=0x2b4d4e885bf0 dsprt=0x2b45552aa080
1% 343 MB, 5615325 chunks: "permanent memory "
qmxlu subheap ds=0x2b4d4e87a4d8 dsprt=0x2b4d4e883948
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 |