SELECT
  inst_id,                                 -- INST_ID NUMBER
  indx,                                    -- SID NUMBER
  ksusmser,                                -- SERIAL# NUMBER
  decode(                                  -- STATE VARCHAR2(9)
    ksusmcrsta, 0, 'NONE', 1, 'MARKED', 2, 'SUSPENDED', 3, 'CAPINIT', 4, 'CAPTURED',5, 'RESINIT', 6, 'RESTORED',7, 'FAILED'),
  decode(                                  -- CRMODE VARCHAR2(7)
    ksusmcrmod, 0, 'SESSION', 1, 'GLOBAL'),
  decode(                                  -- SCOPE VARCHAR2(7)
    ksusmcrcsp, 0, 'NONE', 1, 'MINIMAL', 2, 'TYPICAL', 3, 'FULL'),
  decode(                                  -- NC_COMPONENT VARCHAR2(40)
    ksusmcrncc, -1,'UNKNOWN', 0, 'NONE', ksusmcrncc),
  ksusmcrncr,                              -- NC_REASON NUMBER
  ksusmcropt,                              -- OPTIONS NUMBER
  ksusmcrsto                               -- TIMEOUT NUMBER
FROM
  x$ksusm
WHERE
  (bitand(ksspaflg, 1) != 0)