ORA-04021: timeout occurred while waiting to lock object
LIBRARY CACHE LOCK HOLDERS ->
SELECT SID,SERIAL#,USERNAME,STATUS,SCHEMANAME,OSUSER,MACHINE,PROGRAM,SQL_ID
FROM v$session
WHERE saddr
IN ( SELECT kgllkses
FROM x$kgllk lock_a
WHERE kgllkmod > 0
AND exists (SELECT lock_b.kgllkhdl from x$kgllk lock_b
WHERE kgllkses IN (SELECT saddr FROM v$session WHERE event= 'library cache lock') /* blocked session */
AND lock_a.kgllkhdl = lock_b.kgllkhdl
AND kgllkreq > 0)
);
kamil.piorekk@gmail.com
Best regards /
Komentarze
Prześlij komentarz