重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-13541: system moving window baseline size (691200) greater than (432000) [打印本页]

作者: 郑全 时间: 2023-11-15 17:46
标题: 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.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)