Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-03
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


DBA_TSM_SOURCE lists transparent session migration (TSM) source session statistics.

Column Datatype NULL Description
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   Instance start time of source session
SEQUENCE# NUMBER   Migration sequence number
SOURCE_SID NUMBER   Session ID of source session
SOURCE_SERIAL# NUMBER   Source serial number 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   Start time for migration on source session
COST NUMBER   Estimate of migration cost
FAILURE_REASON VARCHAR2(34)   Reason for migration failure, if any
SOURCE_END_TIME TIMESTAMP(6) WITH TIME ZONE   End time for migration on source session
ROUNDTRIPS NUMBER   Number of client-server round trips during migration
SOURCE_USER_NAME VARCHAR2(30) NOT NULL User associated with the source session
SOURCE_SCHEMA_NAME VARCHAR2(30) NOT NULL Schema associated with the source session
DESTINATION_DATABASE_NAME VARCHAR2(4000)   Database name of the destination session