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_DESTINATION

Object Details

Object Name:	DBA_TSM_DESTINATION
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
DESTINATION_DATABASE_NAME	VARCHAR2	(4000)		Database name of destination session
DESTINATION_INSTANCE_NAME	VARCHAR2	(4000)		Instance name of destination session
DESTINATION_INSTANCE_ID	VARCHAR2	(4000)		Instance id of destination session
DESTINATION_INST_START_TIME	TIMESTAMP(6) WITH TIME ZONE	(13)		Instance start time of destination session
SEQUENCE#	NUMBER			Migration sequence number
DESTINATION_SID	NUMBER			Session id of destination session
DESTINATION_SERIAL#	NUMBER			Session serial# of destination session
DESTINATION_START_TIME	TIMESTAMP(6) WITH TIME ZONE	(13)		Start time for migration on destination session
DESTINATION_END_TIME	TIMESTAMP(6) WITH TIME ZONE	(13)		End time for migration on destination session
DESTINATION_USER_NAME	VARCHAR2	(128)	Yes	User associated with the destination session
DESTINATION_SCHEMA_NAME	VARCHAR2	(128)	Yes	Schema associated with the destination session
DESTINATION_STATE	VARCHAR2	(24)		Migration state of destination session

Query Text

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


SELECT SOURCE_DATABASE_NAME
,      DESTINATION_DATABASE_NAME
,      DESTINATION_INSTANCE_NAME
,      DESTINATION_INSTANCE_ID
,      DESTINATION_INST_START_TIME
,      SEQUENCE#
,      DESTINATION_SID
,      DESTINATION_SERIAL#
,      DESTINATION_START_TIME
,      DESTINATION_END_TIME
,      DESTINATION_USER_NAME
,      DESTINATION_SCHEMA_NAME
,      DESTINATION_STATE
FROM SYS.DBA_TSM_DESTINATION;

Dependencies

[top of page]

SYS.DBA_TSM_DESTINATION references the following:

SYS: TSM_DST$; USER$

SYS.DBA_TSM_DESTINATION is referenced by following:

PUBLIC: DBA_TSM_DESTINATION
SYS: DBA_TSM_HISTORY