Database Tuning (MOSC)

MOSC Banner

Open AUDIT_TRAIL effect performance

edited Jul 5, 2011 10:58PM in Database Tuning (MOSC) 7 commentsAnswered
 Dear all,

    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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center