ORA-13541: system moving window baseline size (691200) greater than (432000)

郑全

SQL> exec dbms_workload_repository.modify_snapshot_settings(interval=>30, retention=>5*24*60);
BEGIN dbms_workload_repository.modify_snapshot_settings(interval=>30, retention=>5*24*60); END;

*
ERROR at line 1:
ORA-13541: system moving window baseline size (691200) greater than retention (432000)
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 213
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 265
ORA-06512: at line 1

SQL> r
  1* select dbid,baseline_name,baseline_type,moving_window_size from dba_hist_baseline

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

SQL> exec dbms_workload_repository.modify_baseline_window_size(2);

PL/SQL procedure successfully completed.


SQL> exec DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(interval=>30,retention => 5*24*60 );

PL/SQL procedure successfully completed.