首页 > 其他分享 >sysaux表空间AUD$UNIFIED统一审计日志过大

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

时间:2023-02-05 22:46:32浏览次数:42  
标签:audit UNIFIED dbms container AUD sysaux trail mgmt last

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;
/

 

 

 

 

标签:audit,UNIFIED,dbms,container,AUD,sysaux,trail,mgmt,last
From: https://www.cnblogs.com/hanglinux/p/17094113.html

相关文章