Create Table Statement Fails with ORA-4030 (qmxlu Subheap,qmemNextBuf:rel Alloc) (Doc ID 2095124.1)

Last updated on JANUARY 07, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
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

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