ORA-04031 Error And A Query Results In Very High "Kzekm Heapt De" Usage Within Shared Pool (Doc ID 1339846.1)

Last updated on JULY 20, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 10.2.0.5 - Release: 10.2 to 10.2
Information in this document applies to any platform.

Symptoms

ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select obj#,type#,ctime,mtim...","sql area","tmp")

The trace file shows:

Subpool 1
---------------
"free memory " 25618792
"kzekm heapt de " 383375880

We have already increased the shared pool size from 400 MB to 500 MB and then to 600 MB. Each time, when the procedure was rerun, it once again showed an increase in the f shared pool allocation "kzekm heapt de" until it was consuming almost all of shared pool.

When the heap dump is taken it shows:

---> HEAP DUMP heap name="kzekm heapt de" desc=3abfffda0
Type Count Sum Average
~~~~ ~~~~~ ~~~ ~~~~~~~
freeable 1667548 492334912 295.24
free 1511 3828736 2533.91

BreakDown
~~~~~~~~~
Type Count Sum Average Percent
~~~~ ~~~~~ ~~~ ~~~~~~~ ~~~~~~~
kzekmram 78091 364287032 4664.90 73.42
Free(heap.awk) 1511 3828736 2533.91 0.77
kzekmalm 1146153 89782640 78.33 18.10
kzekmgwl 443304 38265240 86.32 7.71

Total = 496163648 bytes 484534.81k 473.18MB

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