select
  inst_id,                                 -- INST_ID NUMBER
  indx,                                    -- SID NUMBER
  ksusmser,                                -- SERIAL# NUMBER
  decode(                                  -- STATE VARCHAR2(24)
    ksusmsta, 0, 'NONE', 1, 'SELECTED', 2, 'COMMITED SELECT', 3, 'READY FOR PREPARE', 4, 'PREPARED', 5, 'READY FOR SWITCH', 6, 'SWITCHED', 7, 'FAILED', 8, 'READY FOR STATE TRANSFER', 9, 'IN STATE TRANSFER', 10, 'END OF STATE TRANSFER', 'UNKNOWN'),
  decode(                                  -- MIGRATABLE VARCHAR2(3)
    bitand(ksusmflg, 1), 1, 'NO', decode(ksusmbnd, 0, decode(bitand(ksusmflg, 8), 8, 'NO', 'YES'), 'YES')),
  decode(                                  -- MIGRATION_ALLOWED VARCHAR2(3)
    bitand(ksusmflg, 1), 1, 'NO', 'YES'),
  decode(                                  -- TRANSFERABLE VARCHAR2(3)
    bitand(ksusmflg, 8), 8, 'NO', 'YES'),
  decode(                                  -- MIGRATION_BOUNDARY VARCHAR2(3)
    bitand(ksusmflg, 16), 16, 'YES', 'NO'),
  ksusmnmr,                                -- NONMIGRATABILITY_REASON VARCHAR2(4000)
  ksusmnmi,                                -- NONMIGRATABILITY_INFO VARCHAR2(4000)
  ksusmntr,                                -- NONTRANSFERABILITY_REASON VARCHAR2(4000)
  ksusmnti,                                -- NONTRANSFERABILITY_INFO VARCHAR2(4000)
  decode(                                  -- STATELESS VARCHAR2(11)
    ksusmbnd, 0, 'NEVER', 1, 'CALL', 2, 'TRANSACTION', 3, 'APPLICATION', 'UNKNOWN'),
  decode(                                  -- PRESERVE_STATE VARCHAR2(3)
    bitand(ksusmflg, 4), 4, 'YES', 'NO'),
  ksusmcst,                                -- COST NUMBER
  ksusmdst,                                -- DESTINATION VARCHAR2(4000)
  ksusmnrt,                                -- ROUNDTRIPS NUMBER
  ksusmbcm,                                -- BLOCKING_COMPONENT VARCHAR2(4000)
  ksusmstm,                                -- START_TIME DATE
  ksusmseq                                 -- SEQUENCE_NUMBER NUMBER
from
  x$ksusm
where
  (bitand(ksspaflg, 1) != 0) and (bitand(ksusmsfl, 1) != 0)