Display all queues and queue tables
select owner, name, queue_table
from dba_queues;
Check various stats for all queues
set lines 100 pages 999
col queue format a50
select owner || ‘.’ || name queue, waiting, ready, expired
from dba_queues dq, v$aq aq
where dq.qid = aq.qid
order by 2, 3, 4, 1