오라클 감사로그 삭제 및 Clean

select dbms_stats.get_stats_history_retention from dual;
exec dbms_stats.alter_stats_history_retention(3);

declare
  v_tname varchar2(32767);
begin
  v_tname := 'AUTO_STATS_ADVISOR_TASK';
  dbms_stats.drop_advisor_task(v_tname);
end;
/

exec dbms_stats.init_package();

alter table wri$_adv_objects move;
alter index wri$_adv_objects_idx_01 rebuild;
alter index wri$_adv_objects_idx_02 rebuild;
alter index wri$_adv_objects_pk rebuild;

// 감사체크 파라미터 설정삭제
begin
   dbms_audit_mgmt.deinit_cleanup(
      audit_trail_type => dbms_audit_mgmt.audit_trail_all);
end;
/

// 감사로그 수동삭제
begin
   dbms_audit_mgmt.clean_audit_trail(
      audit_trail_type => dbms_audit_mgmt.audit_trail_unified,
      use_last_arch_timestamp => false);
end;
/

select count(*) from sys.FGA_LOG$;
select count(*) from sys.AUD$; 
select count(*) from audsys.AUD$UNIFIED;

truncate table sys.aud$;
truncate table audsys.AUD$UNIFIED;