This discussion is archived
2 Replies Latest reply: May 10, 2013 12:05 AM by Raj Kumar K RSS

SYS_AUTO_SQL_TUNING_TASK exiting with error "1" for execution

Raj Kumar K Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points