[Home] [Help] [Dependency Information]
Object Name: | CDB_TSM_HISTORY |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Transparent session migration statistics in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQUENCE# | NUMBER | Migration sequence number | ||
SOURCE_SID | NUMBER | Session id of the source session | ||
SOURCE_SERIAL# | NUMBER | Serial# of the source session | ||
USER_NAME | VARCHAR2 | (30) | Yes | User name associated with the session |
SCHEMA_NAME | VARCHAR2 | (30) | Yes | Schema name associated with the session |
STATE | VARCHAR2 | (24) | Source session migration state | |
COST | NUMBER | Estimated cost for migration | ||
SOURCE | VARCHAR2 | (4000) | Instance name from which session was migrated | |
SOURCE_INSTANCE_ID | VARCHAR2 | (4000) | Instance id from which session was migrated | |
SOURCE_START_TIME | TIMESTAMP(6) WITH TIME ZONE | (13) | Instance start time from which session was migrated | |
CONNECT_STRING | VARCHAR2 | (4000) | Connect string for destination | |
FAILURE_REASON | VARCHAR2 | (34) | Additional information for migration failure | |
DESTINATION_SID | NUMBER | Session id of the destination session | ||
DESTINATION_SERIAL# | NUMBER | Serial# of the destination session | ||
DESTINATION_STATE | VARCHAR2 | (24) | Destination session migration state | |
DESTINATION | VARCHAR2 | (4000) | Instance name to which session was migrated | |
DESTINATION_INSTANCE_ID | VARCHAR2 | (4000) | Instance id to which session was migrated | |
DESTINATION_START_TIME | TIMESTAMP(6) WITH TIME ZONE | (13) | Instance start time to which session was migrated | |
ROUNDTRIPS | NUMBER | Number of roundtrips during migration | ||
START_TIME | TIMESTAMP(6) WITH TIME ZONE | (13) | Time when migration was started | |
END_TIME | TIMESTAMP(6) WITH TIME ZONE | (13) | Time when migration finished | |
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT SEQUENCE#
, SOURCE_SID
, SOURCE_SERIAL#
, USER_NAME
, SCHEMA_NAME
, STATE
, COST
, SOURCE
, SOURCE_INSTANCE_ID
, SOURCE_START_TIME
, CONNECT_STRING
, FAILURE_REASON
, DESTINATION_SID
, DESTINATION_SERIAL#
, DESTINATION_STATE
, DESTINATION
, DESTINATION_INSTANCE_ID
, DESTINATION_START_TIME
, ROUNDTRIPS
, START_TIME
, END_TIME
, CON_ID
FROM SYS.CDB_TSM_HISTORY;
SYS.CDB_TSM_HISTORY does not reference any database object
SYS.CDB_TSM_HISTORY is referenced by following:
|
|
|