Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Capture Bind Variables for DMLs

PVMJan 4 2015 — edited Jan 23 2015

Hi All,

Environment is 11g R2 (11.2.0.3) RAC (2 Node) + SAP on AIX. There are concurrent DMLs happening on a table from both instances (parallel threads from SAP). Its like sometimes lot of deletes or inserts or updates happening on that table while a select query runs on that table. I am in a need to capture all the values in those DMLs for eg: into a temp table or something like that. I cannot turn on Auditing at this point of time. Could you please let me know your suggestions on this?

Thanks,

Mani

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2015

Added on Jan 4 2015

#general-database-discussions

26 comments

5,170 views