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.
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.
LIBRARY OBJECT HANDLE: handle=3ed91e24 mtx=0x3ed91ed8(0) cdp=0 name=TC.J1
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:
where kglhdadr = kglhdpar;
select substr(kglnaobj,1,30) sub, count(*) from x$kglob
group by substr(kglnaobj,1,30)
order by 1;
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