ORACLE ORA-13541 错误修改

调整AWR保留时间时，报错：
 
SQL> exec dbms_workload_repository.modify_snapshot_settings(interval=>30,retention => 7*24*60);
 
begin dbms_workload_repository.modify_snapshot_settings(interval=>30,retention => 7*24*60); end;
 
ORA-13541: system moving window baseline size (691200) greater than retention (604800)
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 174
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 222
ORA-06512: at line 2


 原因为 检查当前系统的保留时间为8天,1小时采样一次，当前基线为8天，修改


SQL> select * from dba_hist_wr_control;
 
      DBID SNAP_INTERVAL       RETENTION           TOPNSQL
---------- ------------------- ------------------- ----------
1310729769 +00000 01:00:00.0   +00008 00:00:00.0   DEFAULT
 
Executed in 0.047 seconds


SQL> exec dbms_workload_repository.modify_baseline_window_size(5);
 
PL/SQL procedure successfully completed
 
Executed in 0.016 seconds
 
SQL> exec dbms_workload_repository.modify_snapshot_settings(interval=>30,retention => 7*24*60);
 
PL/SQL procedure successfully completed


SQL> select * from dba_hist_wr_control;
 
      DBID SNAP_INTERVAL       RETENTION           TOPNSQL
---------- ------------------- ------------------- ----------
1310729769 +00000 00:30:00.0   +00007 00:00:00.0   DEFAULT