Oracle表空间SYSAUX使用率很高解决案例(2)

select snap_id, begin_interval_time from sys.dba_hist_snapshot order by snap_id;select * from DBA_HIST_WR_CONTROL;begin
    DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(retention =>43200,interval =>30, topnsql =>'MAXIMUM');
end;
/

4.统计信息清理

exec dbms_stats.purge_stats(systimestamp -11);

Linux公社的RSS地址：https://www.linuxidc.com/rssFeed.aspx