Oracle教程

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

本站中文解释

ISTICS

Oracle视图 DBA_STREAMS_TP_COMPONENT_STATISTICS 用于报告流许可证处理器（TP）的元素的统计信息，该信息以实例、应用程序名称和元素名称为依据。

使用方式：

SELECT inst_id,
application_name,
tp_component_name,
current_enqueues,
current_sources,
current_unsent_messages,
cum_enqueues,
cum_sources,
cum_unsent_messages
FROM dba_streams_tp_component_statistics;

官方英文解释

DBA_STREAMS_TP_COMPONENT_STAT displays temporary performance statistics and session statistics about each Replication component.

Column Datatype NULL Description

COMPONENT_ID

NUMBER

NOT NULL

ID of the Replication component

COMPONENT_NAME

VARCHAR2(4000)

Name of the Replication component

COMPONENT_DB

VARCHAR2(128)

Database where the Replication component resides

COMPONENT_TYPE

VARCHAR2(20)

Type of the Replication component:

  • CAPTURE

  • PROPAGATION SENDER

  • PROPAGATION RECEIVER

  • APPLY

  • QUEUE

SUB_COMPONENT_TYPE

VARCHAR2(27)

Type of the Replication subcomponent:

  • LOGMINER READER

  • LOGMINER PREPARER

  • LOGMINER BUILDER

  • CAPTURE SESSION

  • PROPAGATION SENDER+RECEIVER

  • APPLY READER

  • APPLY COORDINATOR

  • APPLY SERVER

SESSION_ID

NUMBER

ID of the Replication session for the Replication component

SESSION_SERIAL#

NUMBER

Serial number of the Replication session for the Replication component

STATISTIC_TIME

DATE

Time that the statistic was taken

STATISTIC_NAME

VARCHAR2(64)

Name of the statistic

STATISTIC_VALUE

VARCHAR2(4000)

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_COMPONENT_STAT 官方解释，作用，如何使用详细说明
分享到：

相关推荐