select
  inst_id,                                 -- INST_ID NUMBER
  addr,                                    -- ADDR RAW(8)
  ksqrsidt,                                -- TYPE VARCHAR2(2)
  ksqrsid1,                                -- ID1 NUMBER
  ksqrsid2                                 -- ID2 NUMBER
from
  x$ksqrs
where
  bitand(ksqrsflg,2)!=0