DBA Data[Home] [Help]

VIEW: SYS.V_$TSM_SESSIONS

Source

View Text - Preformatted

select "SID","SERIAL#","STATE","MIGRATABLE","MIGRATION_ALLOWED","TRANSFERABLE","MIGRATION_BOUNDARY","NONMIGRATABILITY_REASON","NONMIGRATABILITY_INFO","NONTRANSFERABILITY_REASON","NONTRANSFERABILITY_INFO","STATELESS","PRESERVE_STATE","COST","DESTINATION","ROUNDTRIPS","BLOCKING_COMPONENT","START_TIME","SEQUENCE_NUMBER","CON_ID" from v$tsm_sessions
View Text - HTML Formatted

SELECT "SID"
, "SERIAL#"
, "STATE"
, "MIGRATABLE"
, "MIGRATION_ALLOWED"
, "TRANSFERABLE"
, "MIGRATION_BOUNDARY"
, "NONMIGRATABILITY_REASON"
, "NONMIGRATABILITY_INFO"
, "NONTRANSFERABILITY_REASON"
, "NONTRANSFERABILITY_INFO"
, "STATELESS"
, "PRESERVE_STATE"
, "COST"
, "DESTINATION"
, "ROUNDTRIPS"
, "BLOCKING_COMPONENT"
, "START_TIME"
, "SEQUENCE_NUMBER"
, "CON_ID"
FROM V$TSM_SESSIONS