In order to monitor all the AQ (Advanced Queues) related to B2B the following query can be used.
SELECT a.queue_table, a.name, b.waiting, b.ready, b.expired FROM dba_queues a, v$aq b WHERE a.qid = b.qid AND owner = 'B2B';
Thursday, January 1, 2009
Monitoring All the AQ in B2B
Posted by Prasanna at 10:27 PM
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment