GV$TSM_SESSIONS
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)

home |  up  |  mailbox