V$AQ displays statistics for the queues in the database.
• WAITING – Number of messages in the queue in the state ‘WAITING’
• READY – Number of messages in the queue in the state ‘READY’
• EXPIRED – Number of messages in the queue the state ‘EXPIRED’
• TOTAL_WAIT – Total wait time of all ‘READY’ messages in the queue
• AVERAGE_WAIT – Average wait time of ‘READY’ messages in the queue
SQL> select * from V$AQ; QID WAITING READY EXPIRED TOTAL_WAIT AVERAGE_WAIT ---------- ---------- ---------- ---------- ---------- ------------ 3692 0 0 0 0 0 3694 0 0 0 0 0 3699 0 0 0 0 0 3701 0 0 0 0 0 3750 0 0 0 0 0 3752 0 0 0 0 0 3760 0 0 0 0 0 3762 0 0 0 0 0 8 rows selected.
