This section explains how to use standard auditing to audit activities performed on SQL statements, privileges, schema objects, and network or multitier activities.
About Auditing
Where Are Standard Audited Activities Recorded?
Initialization Parameters Used for Auditing
Oracle Database Security Guide