I am using Oracle 18.104.22.168. 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;
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.