column inst_id format 999
column queue_id format 999999
column queue_schema format a20
column queue_name format a30
column enqueued_msgs format 999999999
column dequeued_msgs format 999999999
column last_enqueue_time format a30
column last_dequeue_time format a30

select inst_id,queue_id,queue_schema,queue_name,enqueued_msgs,dequeued_msgs,last_enqueue_time,last_dequeue_time
from GV$PERSISTENT_QUEUES 
where queue_schema like upper('%&1%') and queue_name like upper('%&2%')
order by queue_name,inst_id;