Oracle 视图 DBA_TSM_DESTINATION 官方解释,作用,如何使用详细说明

本站中文解释

Oracle 视图 DBA_TSM_DESTINATION 是 Oracle 数据库的诊断视图,主要用于查看当前数据库中所有的 Tivoli Storage Manager 的目标组合,查看每个 TSM 目标的信息,如 IP 地址、主机名、端口号等,以及当前登录的用户的 TSM 目的地的连接模式。

使用 Oracle 视图 DBA_TSM_DESTINATION 时,可以使用数据库脚本来查询,如下例所示:

SELECT * FROM DBA_TSM_DESTINATION;

官方英文解释

DBA_TSM_DESTINATION lists transparent session migration (TSM) destination session statistics.

Column Datatype NULL Description

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

Instance start time of destination session

SEQUENCE#

NUMBER

Migration sequence number

DESTINATION_SID

NUMBER

Session ID of destination session

DESTINATION_SERIAL#

NUMBER

Session serial number of destination session

DESTINATION_START_TIME

TIMESTAMP(6) WITH TIME ZONE

Start time for migration on destination session

DESTINATION_END_TIME

TIMESTAMP(6) WITH TIME ZONE

End time for migration on destination session

DESTINATION_USER_NAME

VARCHAR2(128)

NOT NULL

User associated with the destination session

DESTINATION_SCHEMA_NAME

VARCHAR2(128)

NOT NULL

Schema associated with the destination session

DESTINATION_STATE

VARCHAR2(24)

Migration state of destination session


数据运维技术 » Oracle 视图 DBA_TSM_DESTINATION 官方解释,作用,如何使用详细说明