Hi Tom,
we need to purge, ARCHIVE and cleanup our SYS.$AUD table.
WE do have a RAC x 2 node as an Active DG too.

We have a self-defined procedure , which is working appropriately (using DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL).
However the table is >700GB and >700 Mil rows.
The procedure runs everyday and retrieves the data from $AUD -> makes a CTAS and inserts the data in regular table based on the date range --> then the appropriate date range would be purged and cleaned up.


SQL> select /*+ PARALLEL(64) */ to_char(ntimestamp#,'YYYYMMDD') as date_aud , COUNT(0) row_num from sys.aud$ group by to_char(ntimestamp#,'YYYYMMDD') ORDER BY to_char(ntimestamp#,'YYYYMMDD');

a partial selection of AUD table:
DATE_AUD ROW_NUM
-------- ----------
20230712 4722355
20230713 4748860
20230714 4231487
20230715 4360975
20230716 4173837
20230717 5148050
20230718 5414122
20230719 4281115
20230720 4599951
20230721 4002760
20230722 3982341
..................
..................
78 rows selected

We use also the max bacth size (1M) for cleanup
.
SELECT * FROM dba_audit_mgmt_config_params;
DB AUDIT CLEAN BATCH SIZE 1000000 STANDARD AUDIT TRAIL

The issue is that the CLEANUP/ARCHIVE is very I/O intensive and takes 4-5 hours to cleanup/archive the data for a single date range, and we can run max 2 times a day (from 12pm to 12am) as some very I/O intensive ETL jobs run before and after this time period.
We also tried to MOVE the TBS to a new ONE , to have new segment optimized TBS for a better performance using:

SQL> BEGIN
DBMS_AUDIT_MGMT.set_audit_trail_location(
audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_FGA_STD,--this moves table FGA_LOG$
audit_trail_location_value => 'NEW_TBS');
END;
/

But the MOVE process (in a down time) takes more than 20hrs , which is not affordable in a PROD system.
WE opened also 2 SRs with no success on an acceptable result in terms of I/O.

Also the AUDIT data is getting produced every day , so that we are running behind, but with every daily CLEANUP we get new data so that it takes forever to catch up.

Unless you recommend any other approach to achieve this challenge? we do have also a snapshot DG in case you have an idea.
Pls let me know if any info missing or need more INPUT.

Thank you very much!
Ali