Hello,
does someone know whether there's a way to write the SQLID and SQL%ROWCOUNT for the current audit entry to the unified audit trail?
I think it's difficult, because an audit entry is written while the triggering statement maybe is still in execution.
At the moment the only way I know is to create DML-triggers to increment a counter for each executed insert/update/delete. Perhaps the count could be written to audit trail via an application context. Unfortunately selects SQL%ROWCOUNT wouldn't be monitored.
Additional infos:
- DB-Version: Oracle Database 12.1.0.2 Enterprise Edition
- OS: Oracle Linux / Power AIX
- Audits: auditing via Oracle Unified Auditing (=> mixed mode)
I hope someone has an idea.
Thanks for replies!
Regards,
Mathias