My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.