Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SYS_AUTO_SQL_TUNING_TASK exiting with error "1" for execution

Raj Kumar KMay 7 2013 — edited May 10 2013

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 7 2013

Added on May 7 2013

#performance-availability, #real-application-clusters

2 comments

1,120 views