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

本站中文解释

ISTICS

Oracle视图DBA_STREAMS_TP_PATH_STATISTICS显示每个流传输路径获取以及应用任务执行的统计信息。它可以报告流数据应用中每个路径的运行状态,并确定输出端点已经处理的流消息总数和路径的当前状态,进而用来诊断路径的运行状况。

要查看该视图,可以使用以下语法:

SELECT * FROM DBA_STREAMS_TP_PATH_STATISTICS;

官方英文解释

DBA_STREAMS_TP_PATH_STAT displays temporary performance statistics about each stream path that exists in the Replication topology.

Column Datatype NULL Description

PATH_ID

NUMBER

ID of the stream path

STATISTIC_TIME

DATE

Time that the statistic was taken

STATISTIC_NAME

VARCHAR2(64)

Name of the statistic

STATISTIC_VALUE

NUMBER

Value of the statistic

STATISTIC_UNIT

VARCHAR2(64)

Unit of the statistic

ADVISOR_RUN_ID

NUMBER

Logical number (1-based) of the Advisor run

ADVISOR_RUN_TIME

DATE

Time that the Advisor was run


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