As a quick follow up on the previous post… If you are using a JMS queue with Oracle´s Advanced Queueing or Streams (as they have been extended to) the previously described tool can´t help you out. You need something else for monitoring AQ.
For this case a blog by a former colleague helps us out. This approach to monitoring AQ boils down to…
Find the queue you want to monitor AQ.
1 2 3 4 5
SELECT owner , queue_table , TYPE , user_comment FROM all_queue_tables
Perform a query.
1 2 3 4 5 6
SELECT msgid , enq_time , enq_uid , qt.user_data.text_vc FROM my_queue_table qt --alter the table name WHERE q_name = 'MY_QUEUE' --alter the queue name