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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,076 views