DBMS_AUDIT_MGMT setup does not purge the aud$ table
Good afternoon,
I am having an issue where an audit purge job is currently running each hour however does not seem to be working for audit records that are prior to the last archive timestamp. I've searched around and found issues with different DBID's causing problems however the DBID of the audit records match the DBID of the instance.
My version is Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production running AIX6
I have added the config as shown below.
SELECT PARAMETER_NAME, PARAMETER_VALUE, AUDIT_TRAIL FROM DBA_AUDIT_MGMT_CONFIG_PARAMS WHERE PARAMETER_NAME LIKE '%INTERVAL%';PARAMETER_NAME --------------------------------------------------------------------------------PARAMETER_VALUE --------------------------------------------------------------------------------AUDIT_TRAIL ----------------------------DEFAULT CLEAN UP INTERVAL 240 STANDARD AUDIT TRAIL DEFAULT CLEAN UP INTERVAL 240 FGA AUDIT TRAIL DEFAULT CLEAN UP INTERVAL 240 OS AUDIT TRAIL DEFAULT CLEAN UP INTERVAL 240 XML AUDIT TRAIL 4 rows selected.SELECT * FROM dba_audit_mgmt_last_arch_ts;AUDIT_TRAIL RAC_INSTANCE LAST_ARCHIVE_TS -------------------- ------------ ----------------------------------STANDARD AUDIT TRAIL 0 10/05/2018 00:00:00.000000 +00:00 FGA AUDIT TRAIL 0 10/05/2018 00:00:00.000000 +00:00 OS AUDIT TRAIL 1 10/05/2018 00:00:00.000000 +01:00 XML AUDIT TRAIL 1 10/05/2018 00:00:00.000000 +01:00 4 rows selected.select min(ntimestamp#) from sys.aud$MIN(NTIMESTAMP#) --------------------------------------------------09/05/2018 14:01:32.130633 1 row selected.