GV$_LOCK
select USERENV ('Instance'), -- INST_ID NUMBER laddr, -- LADDR RAW(4) kaddr, -- KADDR RAW(4) saddr, -- SADDR RAW(4) raddr, -- RADDR RAW(4) lmode, -- LMODE NUMBER request, -- REQUEST NUMBER ctime, -- CTIME NUMBER block -- BLOCK NUMBER from v$_lock1 union all select inst_id, -- INST_ID NUMBER addr, -- LADDR RAW(4) ksqlkadr, -- KADDR RAW(4) ksqlkses, -- SADDR RAW(4) ksqlkres, -- RADDR RAW(4) ksqlkmod, -- LMODE NUMBER ksqlkreq, -- REQUEST NUMBER ksqlkctim, -- CTIME NUMBER ksqlklblk -- BLOCK NUMBER from x$ktadm where bitand (kssobflg, 1) !=0 and (ksqlkmod!=0 or ksqlkreq!=0) union all select inst_id, -- INST_ID NUMBER addr, -- LADDR RAW(4) ksqlkadr, -- KADDR RAW(4) ksqlkses, -- SADDR RAW(4) ksqlkres, -- RADDR RAW(4) ksqlkmod, -- LMODE NUMBER ksqlkreq, -- REQUEST NUMBER ksqlkctim, -- CTIME NUMBER ksqlklblk -- BLOCK NUMBER from x$ktcxb where bitand (ksspaflg, 1) !=0 and (ksqlkmod!=0 or ksqlkreq!=0)

home |  up  |  mailbox