Client requested to audit all user SQL statements to check who is accessing the data. We are going to implement `execute’ audit policy. How much it will impact performance of the database??
Hello,
my experience with many db and a subset of table from every db, say that there no high impact on CPU, what can encrease
is the I/O when write data in execute file when buffer is full.
Note that in my case that I/O encrease less then 1% and take note the audit files are in common directioy shared via NFS in
another server.