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

本站中文解释

Oracle视图DBA_TSM_SOURCE是数据字典视图,它显示当前安装的Tivoli Storage Management (TSM)提供程序的信息。TSM提供程序可以将归档对象保存到Tivoli存储库中。

DBA_TSM_SOURCE视图提供了使用Tivoli Storage Management的功能的访问工具。它还提供了关于计算存档的元数据的信息,包括TSM服务器的名称。

要使用DBA_TSM_SOURCE视图,Oracle数据库管理员可以使用SELECT语句和WHERE子句进行查询,以查看可用的Tivoli Storage Management提供程序信息。

官方英文解释

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


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