Use this statement to clear the data of the system tables EXA_DBA_AUDIT_SESSIONS, EXA_DBA_AUDIT_SQL, EXA_USER_TRANSACTION_CONFLICTS_LAST_DAY, and EXA_DBA_TRANSACTION_CONFLICTS. This can be necessary if the gathered data volume is too big.
The user should have the DBA role.
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).