Display all queues and queue tables
set lines 100 pages 999
col owner format a15
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
/
|
