Open AUDIT_TRAIL effect performance
I have a question when open audit_trail=db_extended. The execution time becomes slow. The script for audit is the following
audit insert,update,delete on table xxx by access whenever successful;
When I run insert into xxx for 100k rows.(100k statements).
The execution time before insert is 8 seconds, after audit is 48seconds.
Actually I want to filter IPAddress, Ex if session was created by 127.0.0.1, no audit all. is there a way to filter IPAddress?
Or may be filter program, Ex. If Session was created by JDBC, noaudit all.
Thank you