V$AQ displays statistics for the queues in the database.
| Column | Datatype | Description |
|---|---|---|
QID |
NUMBER |
Unique queue identifier |
WAITING |
NUMBER |
Number of messages in the queue in the state 'WAITING' |
READY |
NUMBER |
Number of messages in the queue in the state 'READY' |
EXPIRED |
NUMBER |
Number of messages in the queue the state 'EXPIRED' |
TOTAL_WAIT |
NUMBER |
Total wait time of all 'READY' messages in the queue |
AVERAGE_WAIT |
NUMBER |
Average wait time of 'READY' messages in the queue |