Oracle教程 2023-04-07

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

本站中文解释

_ALL

V$EQ_SUBSCRIBER_STAT_ALL视图提供有关Oracle Streams分发(distribution)的实时状态信息，包括操作次数、错误数以及最后一次执行操作的开始时间等。

V$EQ_SUBSCRIBER_STAT_ALL视图可以帮助运维人员和开发人员了解Oracle Streams分发最新的状态信息，确定功能的可用性和执行的状态，专业的运维更可以收集V$EQ_SUBSCRIBER_STAT_ALL视图的信息来进行趋势分析，以便判断Streams分发的健康程度，以及进而可以检测到的问题的原因。

使用V$EQ_SUBSCRIBER_STAT_ALL视图的示例如下：

— 查看所有订阅者的状态信息
SELECT *
FROM V$EQ_SUBSCRIBER_STAT_ALL;

— 按照订阅者名称查看上一次操作的开始时间
SELECT SUBSCRIBER_NAME, LATEST_EXECUTE_BEGIN_TIME
FROM V$EQ_SUBSCRIBER_STAT_ALL;

— 查看已经失败的操作次数
SELECT SUBSCRIBER_NAME, FAILURES
FROM V$EQ_SUBSCRIBER_STAT_ALL
WHERE FAILURES > 0;

官方英文解释

V$EQ_SUBSCRIBER_STAT displays basic statistical information about the subscribers of Transactional Event Queue (TEQ) event streams. There is one row per queue per event stream per subscriber.

Column	Datatype	Description
`QUEUE_ID`	`NUMBER`	Queue identifier
`SUBSCRIBER_ID`	`NUMBER`	Subscriber identifier
`EVENT_STREAM_ID`	`NUMBER`	Event stream identifier
`PRIORITY`	`NUMBER`	Priority value of the event stream
`MSG_SN`	`NUMBER`	Message serial number
`DEQUEUE_PARTITION_ID`	`NUMBER`	Last known dequeue position in this event stream
`ENQUEUED_MSGS`	`NUMBER`	Number of enqueued messages
`DEQUEUED_MSGS`	`NUMBER`	Number of dequeued messages
`ELAPSED_DEQUEUE_TIME`	`NUMBER`	Amount of time spent performing dequeues (in seconds)
`CPU_DEQUEUE_TIME`	`NUMBER`	Actual amount of CPU time spent performing dequeues (in seconds)
`DEQUEUE_RATE`	`NUMBER`	Number of messages dequeued per second
`DEQUEUE_POSITION`	`RAW(16)`	Message ID at the dequeue position of the subscriber in this event stream A NULL value indicates that either the event stream is empty or no dequeues have been done on this event stream.
`TIME_SINCE_LAST_DEQUEUE`	`NUMBER`	Time since last dequeue activity (in seconds)
`ESTD_TIME_TO_DRAIN`	`NUMBER`	Estimated amount of time to drain the event stream (in seconds) with current enqueue and dequeue rates. Null, if the enqueue rate is greater than the dequeue rate.
`ESTD_TIME_TO_DRAIN_NO_ENQ`	`NUMBER`	Estimated amount of time to drain the event stream (in seconds) with no new enqueues
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

Note:

This view is available starting with Oracle Database 21c.

本站中文解释

官方英文解释

相关推荐