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.DBA_TSM_HISTORY

Object Details

Object Name:	DBA_TSM_HISTORY
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Transparent session migration statistics

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SEQUENCE#	NUMBER			Migration sequence number
SOURCE_SID	NUMBER			Session id of the source session
SOURCE_SERIAL#	NUMBER			Serial# of the source session
USER_NAME	VARCHAR2	(128)	Yes	User name associated with the session
SCHEMA_NAME	VARCHAR2	(128)	Yes	Schema name associated with the session
STATE	VARCHAR2	(24)		Source session migration state
COST	NUMBER			Estimated cost for migration
SOURCE	VARCHAR2	(4000)		Instance name from which session was migrated
SOURCE_INSTANCE_ID	VARCHAR2	(4000)		Instance id from which session was migrated
SOURCE_START_TIME	TIMESTAMP(6) WITH TIME ZONE	(13)		Instance start time from which session was migrated
CONNECT_STRING	VARCHAR2	(4000)		Connect string for destination
FAILURE_REASON	VARCHAR2	(34)		Additional information for migration failure
DESTINATION_SID	NUMBER			Session id of the destination session
DESTINATION_SERIAL#	NUMBER			Serial# of the destination session
DESTINATION_STATE	VARCHAR2	(24)		Destination session migration state
DESTINATION	VARCHAR2	(4000)		Instance name to which session was migrated
DESTINATION_INSTANCE_ID	VARCHAR2	(4000)		Instance id to which session was migrated
DESTINATION_START_TIME	TIMESTAMP(6) WITH TIME ZONE	(13)		Instance start time to which session was migrated
ROUNDTRIPS	NUMBER			Number of roundtrips during migration
START_TIME	TIMESTAMP(6) WITH TIME ZONE	(13)		Time when migration was started
END_TIME	TIMESTAMP(6) WITH TIME ZONE	(13)		Time when migration finished

Query Text

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


SELECT SEQUENCE#
,      SOURCE_SID
,      SOURCE_SERIAL#
,      USER_NAME
,      SCHEMA_NAME
,      STATE
,      COST
,      SOURCE
,      SOURCE_INSTANCE_ID
,      SOURCE_START_TIME
,      CONNECT_STRING
,      FAILURE_REASON
,      DESTINATION_SID
,      DESTINATION_SERIAL#
,      DESTINATION_STATE
,      DESTINATION
,      DESTINATION_INSTANCE_ID
,      DESTINATION_START_TIME
,      ROUNDTRIPS
,      START_TIME
,      END_TIME
FROM SYS.DBA_TSM_HISTORY;

Dependencies

[top of page]

SYS.DBA_TSM_HISTORY references the following:

SYS: DBA_TSM_DESTINATION; DBA_TSM_SOURCE

SYS.DBA_TSM_HISTORY is referenced by following:

PUBLIC: DBA_TSM_HISTORY