Oracle教程 2023-02-24

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

本站中文解释

Oracle视图V$EQ_NONDUR_SUBSCRIBER_LWM提供有关不持久化订阅者的信息。这个视图显示每个不持久化订阅者的最低水平订阅消息编号，其中每个消息的保留期限已过，以及水平订阅和订阅者重置之间的队列消息数量。

使用此视图可查询以下信息：

1）订阅者的最低水平订阅消息编号；

2）哪些消息已过最后保留期（LRM）；

3）水平订阅和订阅者重置之间新消息数量等。

官方英文解释

V$EQ_NONDUR_SUBSCRIBER_LWM projects the low watermarks (LWMs) of non-durable subscribers in a Transactional Event Queue (TEQ). The LWM of a non-durable subscriber is a combination of event stream, priority, and LWM (event queue partition).

Column	Datatype	Description
`QUEUE_ID`	`NUMBER`	Queue ID
`SUBSCRIBER_ID`	`NUMBER`	ID of the non-durable subscriber
`EVENT_STREAM_ID`	`NUMBER`	Event stream ID
`PRIORITY`	`NUMBER`	Priority of the event stream
`LWM`	`NUMBER`	Lower watermark (in an event stream partition) of the non-durable subscriber
`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.

本站中文解释

官方英文解释

相关推荐