CODEWITHSUNDEEP
jmsmuleoracle-aq
Peter Hart
Peter Hart

Reputation: 4975

Oracle AQ - how to determine if a listener is listening to the queue

If I have an AQ set up, but my listener (Mule JMS endpoint) is not receiving any messages. Is there a view that I can query to determine what listeners Oracle thinks are connected to the queue?).

Upvotes: 0

Views: 2773

Answers (1)

David Dossot
David Dossot

Reputation: 33413

From http://wedostreams.blogspot.ca/2009/01/oracle-aq-buffered-queues-101.html:

You can check queue subscribers by querying the AQ$MYQUEUE_TABLE_S view (or AQ$_MYQUEUE_TABLE_S table) like below:

col name    format a12
col address format a40

select name, address
from aq$myqueue_table_s
where queue='MYQUEUE';

NAME      ADDRESS
------------ -------------------------
SUBSCRIBER1
SUBSCRIBER2

Upvotes: 1

Related Questions