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)