6.66 DBA_TSM_SOURCE

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(128)

NOT NULL

User associated with the source session

SOURCE_SCHEMA_NAME

VARCHAR2(128)

NOT NULL

Schema associated with the source session

DESTINATION_DATABASE_NAME

VARCHAR2(4000)

Database name of the destination session