Ora-04030 with high PGA allocation for "kxs-heap-p" under session heap (Doc ID 873392.1)

Last updated on APRIL 23, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.
May also be present in release < 10.2.0.4


Symptoms

ORA-04030: out of process memory when trying to allocate 6688 bytes (session heap,curdefs)

In this case following was observed:

+ More than one session see pga grow more than 4GB and fails with ora-4030.
+ The sessions perform update and select with parallel hint. There is only one table involved in the operation.
+ There is no trigger on table that is getting updated.
+ Trace file shows high allocation under "kxs-heap-p"

---> HEAP DUMP heap name="session heap" desc=0x2b9514d06308
Type Count Sum Average
~~~~ ~~~~~ ~~~ ~~~~~~~
free 76464 47364024 619.43
freeable 1227013 4232464080 3449.40 ------------------->high
recreate 98 126904 1294.94
perm 39 82152 2106.46

BreakDown
~~~~~~~~~
Type Count Sum Average Percent
~~~~ ~~~~~ ~~~ ~~~~~~~ ~~~~~~~
Free(heap.awk) 76464 47364024 619.43 1.11
kxs-heap-w 8 32960 4120.00 0.00
kxs-heap-p 1226516 4232145184 3450.54 98.88 --------------->high
kxs-heap-f 2 8240 4120.00 0.00

The subheap shows high memory usage in permanent chunks for "rworalo : rword"

cprm "rworalo : rword"
cprm "qerpx_open : kx"
cprm "rworalo : rword"
cprm "qerpx_open : kx"

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