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(9) 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