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 Audit Activities Recorded?
Initialization Parameters Used for Auditing
Oracle Database Security Guide