GV$TSM_SESSIONS definition in Oracle Database 10.2 / www.oracledba.ru
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)