Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-03 |
|
|
View PDF |
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 |