TRUNCATE AUDIT LOGS
Purpose
Use this statement to clear the data of the following system tables:
- EXA_DBA_AUDIT_SESSIONS
- EXA_DBA_AUDIT_SQL
- EXA_DBA_IMPERSONATION_LAST_DAY
- EXA_USER_TRANSACTION_CONFLICTS_LAST_DAY
- EXA_USER_IMPERSONATION_LAST_DAY
- EXA_DBA_TRANSACTION_CONFLICTS
This operation can be necessary if the gathered log data volume has grown very large.
Prerequisite
The user must have the DBA role.
Syntax
truncate_audit_logs::=
Usage Notes
You can keep the recent data by using the KEEP option. The semantic for KEEP LAST DAY/MONTH/YEAR is to subtract one day/month/year from the current system timestamp. For instance, KEEP LAST MONTH will delete all logs before ADD_MONTHS(SYSTIMESTAMP, -1).