select
inst_id, -- INST_ID NUMBER
addr, -- LADDR RAW(8)
ksqlkadr, -- KADDR RAW(8)
ksqlkses, -- SADDR RAW(8)
ksqlkres, -- RADDR RAW(8)
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(8)
ksqlkadr, -- KADDR RAW(8)
ksqlkses, -- SADDR RAW(8)
ksqlkres, -- RADDR RAW(8)
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)