dba_kgllock
shows locks and pins that are held on Kernel Generic Library (KGL) cache objects. select -- lck.kgllkuse, ses.sid, ses.serial#, ses.username, lck.kgllkhdl, -- Address of handle for KGL object lck.kgllkmod, -- Current mode lck.kgllkreq, -- Mode or request lck.kgllktype -- Lock or Spin? from dba_kgllock lck left join v$session ses on lck.kgllkuse = ses.saddr ;