GV$_LOCK1
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$kdnssf 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$ksqeq where bitand (kssobflg, 1) !=0 and (ksqlkmod!=0 or ksqlkreq!=0)

home |  up  |  mailbox