ORA-04030 encountered by a process which allocate large free memory

(Doc ID 1439928.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

An oracle foreground process(pga) size may grow extremely large, or an ORA-4030 error may occur.

The ORA-4030 Trace file shows the following :


=======================================
TOP 10 MEMORY USES FOR THIS PROCESS
---------------------------------------
93% 7587 MB, 65126 chunks: "free memory " <<<<<<<<<<<<<<<<<< notice the large free memory here
session heap ds=0x2b506ead37f8 dsprt=0xb7fe5e0
4% 353 MB, 146346 chunks: "kxfqlobf " SQL
kxs-heap-w ds=0x2b506efc2de8 dsprt=0x2b506ead37f8
1% 95 MB, 79672 chunks: "free memory " SQL
kxs-heap-w ds=0x2b506efc2de8 dsprt=0x2b506ead37f8
0% 23 MB, 64926 chunks: "free memory "
top uga heap ds=0xb7fe5e0 dsprt=(nil)
0% 20 MB, 19132 chunks: "permanent memory "
callheap ds=0xb7fd4c0 dsprt=0xb7fe3c0
0% 19 MB, 15370 chunks: "permanent memory " SQL
kxs-heap-w ds=0x2b506efc2de8 dsprt=0x2b506ead37f8
0% 13 MB, 73174 chunks: "kxfqh " SQL
kxs-heap-w ds=0x2b506efc2de8 dsprt=0x2b506ead37f8
0% 10 MB, 49605 chunks: "qbl for partial row " SQL
kxs-heap-w ds=0x2b506efc2de8 dsprt=0x2b506ead37f8
0% 6429 KB, 73174 chunks: "kxfqhlink " SQL
kxs-heap-w ds=0x2b506efc2de8 dsprt=0x2b506ead37f8
0% 2655 KB, 73173 chunks: "kxfqlpbv " SQL
kxs-heap-w ds=0x2b506efc2de8 dsprt=0x2b506ead37f8

=======================================
PRIVATE MEMORY SUMMARY FOR THIS PROCESS
---------------------------------------

*** 2011-10-21 16:23:49.405
******************************************************
PRIVATE HEAP SUMMARY DUMP
8141 MB total:
8118 MB commented, 282 KB permanent
23 MB free (0 KB in empty extents),
8119 MB, 2 heaps: "session heap " 23 MB free held
------------------------------------------------------
Summary of subheaps at depth 1
8114 MB total:
507 MB commented, 20 MB permanent
7587 MB free (0 KB in empty extents),
8090 MB, 1 heap: "kxs-heap-w " 7586 MB free held


If the ORA-4030 error does not occur, but the process size grows very large, a heapdump may show the following:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
---> HEAP DUMP heap name="session heap" desc=0x2b49c94f67f8
Type Count Sum Average
~~~~ ~~~~~ ~~~ ~~~~~~~
free 60148 7.23426e+009 120274.39
freeable 152971 644509272 4213.28
recreate 119 146376 1230.05
perm 31 90560 2921.29

BreakDown
~~~~~~~~~
Type Count Sum Average
~~~~ ~~~~~ ~~~ ~~~~~~~
Free 60148 7.23426e+009 120274.39 <<<<<<<<<<<<<<<<<<<<<< 7GB free memory
kxs-heap-w 119721 507991672 4243.13
kxfpughea:ugi 32477 135198904 4162.91

..
.
.
.

Total = 7.87901e+009 bytes 7694346.11k 7514.01MB <<<<<<<<<<<<<<<<<<<< 7.3GB

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
---> HEAP DUMP heap name="kxs-heap-w" desc=0x2b49ca11e608
Type Count Sum Average
~~~~ ~~~~~ ~~~ ~~~~~~~
free 100341 140220264 1397.44
freeable 374326 345468872 922.91
perm 11435 17485600 1529.13
recreate 7 28072 4010.29

BreakDown
~~~~~~~~~


Type Count Sum Average
~~~~ ~~~~~ ~~~ ~~~~~~~
Free 100341 140220264 1397.44
sort subheap 107 4282536 40023.70
qbl for partial 36116 7226024 200.08
kxfqlobf 135210 311764928 2305.78
kxfqlpbv 67605 2333104 34.51
kxfqhlink 67607 6147672 90.93
kxfqh 67607 12983424 192.04

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