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