2 Replies Latest reply: May 10, 2013 2:05 AM by Raj Kumar K RSS

    SYS_AUTO_SQL_TUNING_TASK exiting with error "1" for execution

    Raj Kumar K
      Hi,

      I'm getting the following entry in my alert log regularly.

      Platform- Windows Server 2008 R2
      Database- 11.2.0.1.0

      Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
      Tue May 07 01:00:42 2013
      SYS_AUTO_SQL_TUNING_TASK exiting with error "1" for execution "EXEC_20763". See DBA_ADVISOR_EXECUTIONS for more details.
      End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
      Errors in file e:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_j006_8736.trc:
      ORA-12012: error on auto execute of job 142691
      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

      Please help me out on this issue.

      Thanks,
      Raj Kumar