My Oracle Support Banner

Unified Audit Records Older Than 30 Days Are Not Purged Using DBMS_MGMT Purge Job (Doc ID 2305499.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

If the last_archive_time is set to anything greater than 30 days then the Purge Job doesn't delete all the data from Unified Audit Trail

However if it's changed from last_archive_time => SYSTIMESTAMP-31 to SYSTIMESTAMP-30 the Purge Job works as expected i.e. it deletes the audit data older than 30 days.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.