SQL> select * from dba_hist_wr_control;

DBID SNAP_INTERVAL RETENTION TOPNSQL
---------- ------------------------------ ------------------------------ ------------------------------
4270115873 +00000 01:00:00.0 +00007 00:00:00.0 DEFAULT

SQL> begin
2 dbms_workload_repository.modify_snapshot_settings(interval=>30,retention=>10*24*60);
3 end;
4 /

PL/SQL procedure successfully completed.

SQL> select * from dba_hist_wr_control;

DBID SNAP_INTERVAL RETENTION TOPNSQL
---------- ------------------------------ ------------------------------ ------------------------------
4270115873 +00000 00:30:00.0 +00010 00:00:00.0 DEFAULT

ITPub博客

AWR修改收集策略

最新文章