| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-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 |
|
 Copyright © 2002, 2003, Oracle Corporation All Rights Reserved. |
|
