8.35 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 (TxEventQs) 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	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	NUMBER	Message latency within the last 5 minutes (in milliseconds). Null if no message is consumed or it is delay dequeue.
MESSAGE_LATENCY_2	NUMBER	Message latency within the last 1 hour (in milliseconds). Null if no message is consumed or it is delay dequeue.
MESSAGE_LATENCY_3	NUMBER	Message latency within the last 5 hours (in milliseconds). Null if no message is consumed or it is delay dequeue.
NUM_DEQUEUE_ATTEMPTSFoot 1	NUMBER	Number of dequeue attempts A single dequeue call may result in multiple internal dequeue attempts, and this value may not match the number of dequeue calls made by the client.
WM_FLAGFoot 1	NUMBER	Reserved for internal use
MIN_READY_MESSAGE_IDFoot 1	RAW(16)	Message ID of the earliest next message (that is, the minimum READY time) with non-zero delay, not yet dequeued by the subscriber
MIN_READY_FLAGFoot 1	NUMBER	Reserved for internal use
MIN_READY_TIMESTAMPFoot 1	TIMESTAMP(6) WITH TIME ZONE	Ready time of the earliest next message (that is, the minimum READY time) with non-zero delay, not yet dequeued by the subscriber
EXPIRED_MSGSFoot 1	NUMBER	Number of messages that were marked as expired before being dequeued by the subscriber
SKIPPED_MSGSFoot 1	NUMBER	Number of messages marked as skipped for rule-based subscribers Messages that do not qualify for the subscriber’s rule are marked as skipped.
DEQUEUE_LWM_SUBSHARDFoot 1	NUMBER	Subshard identifier of the dequeue low watermark
DEQUEUE_LWM_SNFoot 1	NUMBER	Sequence number of the dequeue low watermark message within the subshard identified by DEQUEUE_LWM_SUBSHARD
DEQUEUE_LWM_PROPFoot 1	NUMBER	Indicates the position of the dequeue low watermark relative to the message identified by DEQUEUE_LWM_SN: 0 - The dequeue low watermark is at the message identified by DEQUEUE_LWM_SN. 1 - The dequeue low watermark is after the message identified by DEQUEUE_LWM_SN.
RETENTION_TIME_ELAPSED_MSGS	NUMBER	Number of messages whose retention time elapsed before being dequeued by the subscriber and were therefore marked for purging from the queue This count is incremented only when the queue-level parameter RETENTION_TYPE is set to 1, meaning retention is computed with reference to the message ENQUEUE_TIME. Messages may be purged after the number of seconds specified by the RETENTION_TIME parameter has elapsed.
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 1 This column is available starting with Oracle AI Database 26ai, Release Update 23.26.1.