Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Persistent library cache pin
Often connections get blocked due to a library cache pin exclusive.
The lock seems to be on the sentence -> different spelling no block, and it
seems to
lay on the database. Shooting down the database has no effect on the lock,
next
time sentence is runned, lock is there again even if executed just on
depart.
The query I use to find the locking is included at the end. It returns to
lock with
exclusive mode belonging to the same session and processing same statement.
Anybody has idea what is going on?
The query to find the lock I'm using is: select s.sid,
decode(ob.kglhdnsp, 0, 'Cursor', 1, 'Table/Procedure/Type', 2, 'Body',
3, 'trigger', 4, 'Index', 5, 'Cluster', to_char(ob.kglhdnsp))
|| ' Definition ' || lk.kgllktype,
decode(lk.kgllkmod, 0, 'None', 1, 'Null', 2, 'Share', 3, 'Exclusive',
to_char(lk.kgllkmod)),
decode(lk.kgllkreq, 0, 'None', 1, 'Null', 2, 'Share', 3, 'Exclusive',
to_char(lk.kgllkreq)),
decode(ob.kglnaown, null, '', ob.kglnaown || '.') || ob.kglnaobj ||
decode(ob.kglnadlk, null, '', '@' || ob.kglnadlk),
rawtohex(lk.kgllkhdl)
from v$session s, x$kglob ob, dba_kgllock lk
where lk.kgllkhdl = ob.kglhdadr and lk.kgllkuse = s.saddrReceived on Mon Jan 21 2002 - 10:27:23 CST