8.209 V$EQ_SUBSCRIBER_STAT

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.

See Also:

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