Selecting an Audit Trail Purge Method

You can perform the purge on a regularly scheduled basis or at a specified times.

• Purging the Audit Trail on a Regularly Scheduled Basis
  You can purge all audit records, or audit records that were created before a specified timestamp, on a regularly scheduled basis.

• Purging the Audit Trail on Demand
  You can manually purge the audit records on demand rather than scheduling the purge.

Purging the Audit Trail on a Regularly Scheduled Basis

You can purge all audit records, or audit records that were created before a specified timestamp, on a regularly scheduled basis.

For example, you can schedule the purge for every Saturday at 2 a.m.

1. Ensure that online and archive redo log sizes are tuned to accommodate the additional records generated during the audit table purge process.

2. Plan a timestamp and archive strategy.

3. Optionally, set an archive timestamp for the audit records.

4. Create and schedule the purge job.

Related Topics

• Scheduling an Automatic Purge Job for the Audit Trail

Purging the Audit Trail on Demand

You can manually purge the audit records on demand rather than scheduling the purge.

1. Ensure that online and archive redo log sizes are tuned to accommodate the additional records that were generated during the audit table purge process.

2. Plan a timestamp and archive strategy.

3. Optionally, set an archive timestamp for the audit records.

4. Run the purge operation.

Related Topics

• Manually Purging the Audit Trail