select
  inst_id,                                 -- INST_ID NUMBER
  0,                                       -- SID NUMBER
  0,                                       -- SERIAL# NUMBER
  kmpcsoaddr,                              -- CSOADDR RAW(8)
  kmpcsocqcregid                           -- CACHE_ID NUMBER
from
  x$kmpcso
where
  kmpcsostate != 0
union
  select
    a.inst_id,
    a.ksusenum,
    a.ksuseser,
    hextoraw('0'),
    a.ksuseclregid
  from
    x$ksusecon a,
    x$ksuse b
  where
    a.ksusenum = b.ksusenum and a.ksuseser = b.ksuseser and b.ksspatyp != 4)