Toad World® Forums

Oracle 11g Operational Audit


#1

Oracle 11g on Linux.

Just want to get feedback on how everybody is handling audit within Oracle table access.

I just started the list with:

1: Successful Logins
2: Unsuccessful logins.

What other audits can I turn on without really bogging down the performance of the db.

Thank you.


#2

Here’s a good starting point, from Oracle Docs, but there are other sources too numerous to mention here:

https://docs.oracle.com/cd/B28359_01/server.111/b28337/tdpsg_auditing.htm#TDPSG50522

Stay away from audit levels that attempt to track activity that occurs frequently… e.g. it’s one thing to track Alter System activity, but it may be quite another to try and track Alter Any Table (likely lots more audit entries for this one.)