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;