1 Reply Latest reply: Apr 21, 2014 2:07 AM by Renu-Oracle RSS

    Audit  enqueue dequeue

    Sabin23

      I am using Oracle 11.2.0.3. I have point to point persistent queue implemented through PL/SQL  API.  I have set retention of the queue for 12 months. However,  none of the queue tables/view has information on which server dequeued the message. How can I audit such information?

       

      Also, I had tried  following audit but  I do not see anything in dba_audit_object when i dequeue a message. Am I doing anything wrong?

      audit DEQUEUE ANY QUEUE by access;

        • 1. Re: Audit  enqueue dequeue
          Renu-Oracle

          Hi,

           

          Looks like same query is reported in other open thread.

           

          Messages are exchanged between a client and the Oracle Database server or between two Oracle Database servers using Oracle Net Services. Oracle Net Services also propagates messages from one Oracle Database queue to another.


          You may need to check what all subscribers added to it.


            select subscriber_id, queue_name, name, address, subscriber_type from aq$_<queue_table_name>_s;

           

          Thanks,

          Renu