Oracle Cloud Infrastructure Documentation

Auto Purge

Activity Auditing has an auto purge feature that helps you to manage manage your audit data. Auto purge lets you purge audit records in the Oracle Cloud database targets on a regularly scheduled basis.

The auto purge feature is an operation on a target database. When auto purge is enabled on a target database, audit data in the target database is deleted every seven days so that the database's audit trail does not become too large. Activity Auditing accomplishes this task by creating a cleanup job on the target database and tracking the batch copying activity in the Event Log. For instance, when a batch copy is completed, Oracle Data Safe updates the last archive timestamp in the target database. The cleanup job then deletes audit records that are older than the last archive timestamp.


Audit records are collected continuously from the target database as far back as the number of months specified in the audit data retention period. For example, if the retention period is 12 months, then audit records created only within the last 12 months are collected. Enabling auto purge deletes all audit records in the target database every seven days, including those older than the retention period (hence, not collected in Oracle Data Safe). After considering this impact, you should enable this feature carefully.