DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP and DEFAULT CLEAN UP INTERVAL in dba_audit_mgmt_config_pa

Hi All

Does anyone know what is the relationship between the audit trail management procedure

DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP and the "default clean up interval" parameter in dba_audit_mgmt_config_params.

I have my "Default clean up interval" with 168 hours (7 days) and when the clean up job was running, I can see the delete statement as below

select count(1) FROM SYS.AUD$ WHERE DBID = 629794858 AND NTIMESTAMP# < to_timestamp('2022-06-14 00:00:00', 'YYYY-MM-DD HH24:MI:SS.FF')  
AND ROWNUM <= 140733193398032

The delete statement was trying to remove audit trail records which is 7 days ago and I believe it take the "Default Clean Up interval" value in dba_audit_mgmt_config_params.