4 Replies Latest reply on Dec 13, 2010 4:05 PM by zlesko

    Automatic SQL tuning errors


      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


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