Automatic SQL tuning errors
Hi, 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 Thanks! Edited by: user9213912 on Nov 15, 2010 10:41 AM
which version and os? in 11gr2 there is a bug, check MOS: Bug 9775678: ORA-00001: UNIQUE CONSTRAINT (SYS.WRI$_ADV_SQLT_PLANS_PK) VIOLATED may you have to open a service request with reference to this bug. hth
Hi, check this http://translate.google.co.in/translate?hl=en&sl=ko&u=http://kr.forums.oracle.com/forums/thread.jspa%3FthreadID%3D952867&ei=v3_hTPP4LYmxcbT-vZcM&sa=X&oi=translate&ct=result&resnum=2&ved=0CCYQ7gEwAQ&prev=/search%3Fq%3DSYS.WRI%2524_ADV_SQLT_PLANS_PK%26hl%3Den%26client%3Dfirefox-a%26rls%3Dorg.mozilla:en-US:official%26prmd%3Div
I saw that thread, but this is the auto task, rather than one I created manually, so I wasn't sure it was relevant. That is my version, so I'll investigate the bug route. Was there a patch/fix? Thanks.
184.108.40.206 update seems to have resolved this, fyi.