Database auditing is the process of recording, monitoring and reporting of the actions performed on a database. It allows the security auditors to observe whether the database users are using the database according to the established policies and that there are no policy violations.
Here are the important tables stores information on Audit.
DBA_AUDIT_EXISTS audit trail entries created by the AUDIT EXISTS command.
DBA_AUDIT_OBJECT or USER_AUDIT_OBJECT all/user audit trail records concerning objects.
DBA_AUDIT_SESSION or USER_AUDIT_SESSION all/user audit trail records concerning CONNECT and DISCONNECT.
DBA_AUDIT_STATEMENT or USER_AUDIT_STATEMENT all/user audit trail records concerning GRANT, REVOKE,AUDIT
DBA_AUDIT_TRAIL or USER_AUDIT_TRAIL all/user audit trail records.
Useful information can be found in below MOS notes.
How to Truncate, Delete, or Purge Rows from the Audit Trail Table AUD$ (Doc ID 73408.1)
New Feature DBMS_AUDIT_MGMT To Manage And Purge Audit Information (Doc ID 731908.1)
