Skip to Main Content

Audit enqueue dequeue

OU_230Apr 16 2014 — edited Apr 21 2014

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

Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on May 19 2014
Added on Apr 16 2014
1 comment