ORA-04031 "KGL HANDLES" Memory Leak Of MVOBIND / MVOBTBL From Partition Operations (Doc ID 735485.1)

Last updated on JUNE 15, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4
This problem can occur on any platform.
Applies to:

Symptoms

o Alert log shows memory leak error, ORA-04031:


ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","select job, nvl2(last_date, ...","Typecheck"," kgghteInit")

o A large number of partition operations such as EXCHANGE PARTITION has been performed.

o ORA-04031 trace file shows unfreeable library cache handles with namespace=MVOBIND or namespace=MVOBTBL with "OBS", obsolete, flag.

For example:

LIBRARY OBJECT HANDLE: handle=3ed91e24 mtx=0x3ed91ed8(0) cdp=0 name=TC.J1
hash=9d7c9f4b83bc93dd8786da6b08e0034b
namespace=MVOBIND flags=KGHP/MVR/OBS/SML/[02600000]
kkkk-dddd-llll=0000-0000-0000 lock=0 pin=0 latch#=3 hpc=0000 hlc=0000


o Running the following queries show count is growning overtime:

select count(*)
from x$kglob
where kglhdadr = kglhdpar;

select substr(kglnaobj,1,30) sub, count(*) from x$kglob
group by substr(kglnaobj,1,30)
having count(*)>200
order by 1;

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