4 Replies Latest reply: Dec 13, 2010 10:05 AM by zlesko RSS

    Automatic SQL tuning errors

    zlesko
      Hi,

      Getting the following every time an automatic SQL tuning maintenance task runs... any ideas? The job fails as a result.

      This is 11gR2 RAC on Linux x64.

      ORA-00001: unique constraint (SYS.WRI$_ADV_SQLT_PLANS_PK) violated
      ORA-06512: at "SYS.PRVT_ADVISOR", line 2693
      ORA-06512: at "SYS.DBMS_ADVISOR", line 241
      ORA-06512: at "SYS.DBMS_SQLTUNE", line 772 ORA-06512: at line 4

      Thanks!

      Edited by: user9213912 on Nov 15, 2010 10:41 AM