7.28 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.
Column | Datatype | Description |
---|---|---|
|
|
Queue identifier |
|
|
Subscriber identifier |
|
|
Shard identifier |
|
|
Priority value of the shard |
|
|
Last known dequeue position in this shard |
|
|
Number of enqueued messages |
|
|
Number of dequeued messages |
|
|
Amount of time spent performing dequeues (in seconds) |
|
|
Actual amount of CPU time spent performing dequeues (in seconds) |
|
|
Number of messages dequeued per second |
|
|
Time since last dequeue activity (in seconds) |
|
|
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. |
|
|
Estimated amount of time to drain the shard (in seconds) with no new enqueues |
|
|
The ID of the container to which the data pertains. Possible values include:
|