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
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.
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?