V$TSM_SESSIONS definition in Oracle Database 11.2
V$TSM_SESSIONS
select
sid, -- SID NUMBER
serial#, -- SERIAL# NUMBER
state, -- STATE VARCHAR2(24)
migratable, -- MIGRATABLE VARCHAR2(3)
migration_allowed, -- MIGRATION_ALLOWED VARCHAR2(3)
transferable, -- TRANSFERABLE VARCHAR2(3)
migration_boundary, -- MIGRATION_BOUNDARY VARCHAR2(3)
nonmigratability_reason, -- NONMIGRATABILITY_REASON VARCHAR2(4000)
nonmigratability_info, -- NONMIGRATABILITY_INFO VARCHAR2(4000)
nontransferability_reason, -- NONTRANSFERABILITY_REASON VARCHAR2(4000)
nontransferability_info, -- NONTRANSFERABILITY_INFO VARCHAR2(4000)
stateless, -- STATELESS VARCHAR2(11)
preserve_state, -- PRESERVE_STATE VARCHAR2(3)
cost, -- COST NUMBER
destination, -- DESTINATION VARCHAR2(4000)
roundtrips, -- ROUNDTRIPS NUMBER
blocking_component, -- BLOCKING_COMPONENT VARCHAR2(4000)
start_time, -- START_TIME DATE
sequence_number -- SEQUENCE_NUMBER NUMBER
from
gv$tsm_sessions
where
inst_id = USERENV('Instance')