sysaux表空间AUD$UNIFIED统一审计日志过大

1.设置保留时间点

 

begin
    dbms_audit_mgmt.set_last_archive_timestamp(
    audit_trail_type => dbms_audit_mgmt.audit_trail_unified,
    last_archive_time => sysdate -1,
    container => dbms_audit_mgmt.container_current);
end;
/

 

 

 

2.清理

 

begin
    dbms_audit_mgmt.clean_audit_trail(
    audit_trail_type => dbms_audit_mgmt.audit_trail_unified,
    use_last_arch_timestamp => true,
    container => dbms_audit_mgmt.container_current);
end;
/