Collected posts: Oracle, SQL, PL/SQL, Performance, Security...(More than 300 blogs)

jeudi 29 novembre 2018

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;

Aucun commentaire:

Enregistrer un commentaire