Audit all Oracle user activity.

Audit all Oracle user activity.
This audits everything including DDL (create table), DML (inserts, updates, deletes) and login/logoff events:
audit all by FRED by access;
Audit all Oracle user viewing activity:
audit select table by FRED by access;
Audit all Oracle user data change activity:
audit update table, delete table,
insert table by FRED by access;
Audit all Oracle user viewing activity:
audit execute procedure by FRED by access;
We can also query the dba_audit_trail view. Here are the column descriptions from the Oracle documentation: