[Home] [Help] [Dependency Information]
Object Name: | CDB_TSM_SOURCE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Transparent session migration source session statistics in all containers
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 | (30) | Yes | User associated with the source session |
SOURCE_SCHEMA_NAME | VARCHAR2 | (30) | Yes | Schema associated with the source session |
DESTINATION_DATABASE_NAME | VARCHAR2 | (4000) | Database name of destination session | |
CON_ID | NUMBER | container id |
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
, CON_ID
FROM SYS.CDB_TSM_SOURCE;
SYS.CDB_TSM_SOURCE does not reference any database object
SYS.CDB_TSM_SOURCE is referenced by following:
|
|
|