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_ATTEMPTS`Foot 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_FLAG`Foot 1	`NUMBER`	Reserved for internal use
`MIN_READY_MESSAGE_ID`Foot 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_FLAG`Foot 1	`NUMBER`	Reserved for internal use
`MIN_READY_TIMESTAMP`Foot 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_MSGS`Foot 1	`NUMBER`	Number of messages that were marked as expired before being dequeued by the subscriber
`SKIPPED_MSGS`Foot 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_SUBSHARD`Foot 1	`NUMBER`	Subshard identifier of the dequeue low watermark
`DEQUEUE_LWM_SN`Foot 1	`NUMBER`	Sequence number of the dequeue low watermark message within the subshard identified by `DEQUEUE_LWM_SUBSHARD`
`DEQUEUE_LWM_PROP`Foot 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.