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