Oracle教程 2023-03-22

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

分享到：

本站中文解释

官方英文解释

相关推荐