ORA-13511: Error Code and Solution Suggestion

 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

BEGIN   DBMS_WORKLOAD_REPOSITORY.modify_snapshot_settings(     interval  => 5);          -- Minutes. Current value retained if NULL. END; -------- -------------------------------- --------------- --------------- ORA-13511: invalid INTERVAL 5, must be in the range (10, 52560000) ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 198 ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 246 ORA-06512: at line 2 -------- -------------------------------- --------------- --------------- ORA-13511: invalid INTERVAL string, must be in the range (string, string) Cause: The user has specified a INTERVAL setting that is not in the supported range of (MIN, MAX). Action: Choose a valid INTERVAL setting and retry the operation.   BEGIN   DBMS_SCHEDULER.CREATE_JOB(   job_name        => 'DBMS_WORKLOAD_REPOSITORY_CHB',   job_type        => 'PLSQL_BLOCK',   job_action      => 'BEGIN DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); END;',   start_date      => SYSDATE,   repeat_interval => 'FREQ=MINUTELY;INTERVAL=3',      end_date        => SYSDATE + 1 / 24,   enabled         => TRUE,   comments        => 'DBMS_WORKLOAD_REPOSITORY_CHB'); END;