
We used to have auditing enabled in oracle 12R1 database. due to which 120GG space is occupied in AUDSYS.CLI_SWP$XXX.
Currently we had disabled the unified auditing and move the aud$ table to new tablespace to avoid growing of sysaux tablespace.
We tried to clear/purge the audsys.CLI_SWP$XXX data using the below package.
BEGIN
DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(
audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,
use_last_arch_timestamp => TRUE);