eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.GV_$TSM_SESSIONS

Object Details

Object Name:	GV_$TSM_SESSIONS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
INST_ID	NUMBER
SID	NUMBER
SERIAL#	NUMBER
STATE	VARCHAR2	(24)
MIGRATABLE	VARCHAR2	(3)
MIGRATION_ALLOWED	VARCHAR2	(3)
TRANSFERABLE	VARCHAR2	(3)
MIGRATION_BOUNDARY	VARCHAR2	(3)
NONMIGRATABILITY_REASON	VARCHAR2	(4000)
NONMIGRATABILITY_INFO	VARCHAR2	(4000)
NONTRANSFERABILITY_REASON	VARCHAR2	(4000)
NONTRANSFERABILITY_INFO	VARCHAR2	(4000)
STATELESS	VARCHAR2	(11)
PRESERVE_STATE	VARCHAR2	(3)
COST	NUMBER
DESTINATION	VARCHAR2	(4000)
ROUNDTRIPS	NUMBER
BLOCKING_COMPONENT	VARCHAR2	(4000)
START_TIME	DATE
SEQUENCE_NUMBER	NUMBER
CON_ID	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INST_ID
,      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 SYS.GV_$TSM_SESSIONS;

Dependencies

[top of page]

SYS.GV_$TSM_SESSIONS references the following:

SYS.GV_$TSM_SESSIONS is referenced by following:

PUBLIC: GV$TSM_SESSIONS