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')

home |  up