1. Database Reference
  2. Dynamic Performance Views
  3. Dynamic Performance (V$) Views: V$ACCESS to V$HVMASTER_INFO
  4. V$EQ_NONDUR_SUBSCRIBER_LWM

8.215 V$EQ_NONDUR_SUBSCRIBER_LWM

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.

See Also:

Oracle Database Advanced Queuing User's Guide for more information about Oracle Transactional Event Queues and Advanced Queuing