My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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


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
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;


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

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