Oracle教程 2023-02-24

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

本站中文解释

Oracle视图V$AQ_SHARDED_SUBSCRIBER_STAT用于报告分片订阅者的信息，包括分片订阅者的角色、状态、负责的块数量等信息，以确定订阅和发布消息的处理状况。可以查看每个分片订阅者实例已消费的消息数，以检查消息处理的情况。

要使用V$AQ_SHARDED_SUBSCRIBER_STAT视图，首先需要在数据库中建立订阅者。接下来，使用SELECT子句从视图V$AQ_SHARDED_SUBSCRIBER_STAT获取所需的信息，例如：

SELECT * FROM v$aq_sharded_subscriber_stat;

这将返回所有分片订阅者的信息，可以从中检查订阅者的状态，以确保消息正常消费。此外，也可以使用此视图检查每个分片订阅者之间的扩展情况，以确保分片情况的一致性。

官方英文解释

V$AQ_SHARDED_SUBSCRIBER_STAT displays basic statistical information about the subscribers of sharded queues. There is one row per queue per shard per subscriber.

Note:

AQ sharded queues are deprecated in Oracle Database 21c. Oracle recommends that you instead use Transactional Event Queues (TEQs) for higher throughput and better performance.

Column	Datatype	Description
`QUEUE_ID`	`NUMBER`	Queue identifier
`SUBSCRIBER_ID`	`NUMBER`	Subscriber identifier
`SHARD_ID`	`NUMBER`	Shard identifier
`PRIORITY`	`NUMBER`	Priority value of the shard
`MSG_SN`	`NUMBER`	Message serial number
`DEQUEUE_SUBSHARD`	`NUMBER`	Last known dequeue position in this shard
`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`^Foot 1	`RAW(16)`	Message ID at the dequeue position of the subscriber in this shard A NULL value indicates that either the shard is empty or no dequeues have been done on this shard.
`TIME_SINCE_LAST_DEQUEUE`	`NUMBER`	Time since last dequeue activity (in seconds)
`ESTD_TIME_TO_DRAIN`	`NUMBER`	Estimated amount of time to drain the shard (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 shard (in seconds) with no new enqueues
`MESSAGE_LATENCY_1`^Foot 1	`NUMBER`	Message latency within the last 5 minutes (in milliseconds). Null if no message is consumed or it is delay dequeue.
`MESSAGE_LATENCY_2`^Foot 1	`NUMBER`	Message latency within the last 1 hour (in milliseconds). Null if no message is consumed or it is delay dequeue.
`MESSAGE_LATENCY_3`^Foot 1	`NUMBER`	Message latency within the last 5 hours (in milliseconds). Null if no message is consumed or it is delay dequeue.
`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

^Footnote 1This column is available starting with Oracle Database 21c.

数据运维技术 » Oracle 视图 V$AQ_SHARDED_SUBSCRIBER_STAT 官方解释，作用，如何使用详细说明

分享到：

本站中文解释

官方英文解释

相关推荐