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_SOURCE

Object Details

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

Transparent session migration source session statistics

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SOURCE_DATABASE_NAME	VARCHAR2	(4000)		Database name of source session
SOURCE_INSTANCE_NAME	VARCHAR2	(4000)		Instance name of source session
SOURCE_INSTANCE_ID	VARCHAR2	(4000)		Instance id of source session
SOURCE_INSTANCE_START_TIME	TIMESTAMP(6) WITH TIME ZONE	(13)		Instance start time of source session
SEQUENCE#	NUMBER			Migration sequence number
SOURCE_SID	NUMBER			Session id of source session
SOURCE_SERIAL#	NUMBER			Session serial# of source session
SOURCE_STATE	VARCHAR2	(24)		Migration state of source session
CONNECT_STRING	VARCHAR2	(4000)		Connect string specified for migration
SOURCE_START_TIME	TIMESTAMP(6) WITH TIME ZONE	(13)		Start time for migration on source session
COST	NUMBER			Estimate migration cost
FAILURE_REASON	VARCHAR2	(34)		Failure reason for migration if any
SOURCE_END_TIME	TIMESTAMP(6) WITH TIME ZONE	(13)		End time for migration on source session
ROUNDTRIPS	NUMBER			Number of client-server round-trips during migration
SOURCE_USER_NAME	VARCHAR2	(128)	Yes	User associated with the source session
SOURCE_SCHEMA_NAME	VARCHAR2	(128)	Yes	Schema associated with the source session
DESTINATION_DATABASE_NAME	VARCHAR2	(4000)		Database name of destination session

Query Text

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


SELECT SOURCE_DATABASE_NAME
,      SOURCE_INSTANCE_NAME
,      SOURCE_INSTANCE_ID
,      SOURCE_INSTANCE_START_TIME
,      SEQUENCE#
,      SOURCE_SID
,      SOURCE_SERIAL#
,      SOURCE_STATE
,      CONNECT_STRING
,      SOURCE_START_TIME
,      COST
,      FAILURE_REASON
,      SOURCE_END_TIME
,      ROUNDTRIPS
,      SOURCE_USER_NAME
,      SOURCE_SCHEMA_NAME
,      DESTINATION_DATABASE_NAME
FROM SYS.DBA_TSM_SOURCE;

Dependencies

[top of page]

SYS.DBA_TSM_SOURCE references the following:

SYS: TSM_SRC$; USER$

SYS.DBA_TSM_SOURCE is referenced by following:

PUBLIC: DBA_TSM_SOURCE
SYS: DBA_TSM_HISTORY