8.213 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