AWR修改收集策略

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