修改oracle awr修改信息收集频率

1.查看系统的当前的MOVING_WINDOW_SIZE

SQL> select dbid,baseline_name,baseline_type,moving_window_size from dba_hist_baseline;

 DBID BASELINE_NAME          BASELINE_TYPE MOVING_WINDOW_SIZE
---------- ---------------        ------------- ------------------
1284003062 SYSTEM_MOVING_WINDOW   MOVING_WINDOW             8

2.查看当前awr 收集频率(默认每隔一小时收集一次，存放8天)

SQL>select * from dba_hist_wr_control;

      DBID SNAP_INTERVAL        RETENTION            TOPNSQL
---------- -------------------- -------------------- ----------
1579622143 +00 01:00:00.000000 +08 00:00:00.000000 DEFAULT

3.现修改没10分钟收集一次，存放5天

exec dbms_workload_repository.modify_baseline_window_size(2);
exec DBMS_WORKLOAD_REPOS