GV$LOCKED_OBJECT

select
x.inst_id,               -- INST_ID NUMBER
x.kxidusn,               -- XIDUSN NUMBER
x.kxidslt,               -- XIDSLOT NUMBER
x.kxidsqn,               -- XIDSQN NUMBER
l.ktadmtab,              -- OBJECT_ID NUMBER
s.indx,                  -- SESSION_ID NUMBER
s.ksuudlna,              -- ORACLE_USERNAME VARCHAR2(30)
s.ksuseunm,              -- OS_USER_NAME VARCHAR2(30)
s.ksusepid,              -- PROCESS VARCHAR2(12)
l.ksqlkmod               -- LOCKED_MODE NUMBER
from
x$ktcxb x,
x$ktadm l,
x$ksuse s 
where
x.ktcxbxba = l.kssobown and x.ktcxbses = s.addr
home |  up  |  mailbox