Workaround for ORA-00001: unique constraint (SYS.WRI$_ADV_SQLT_PLANS_PK) violated
Hi,
We are getting below error daily from our production database (11.2.0.1) and we need to know
whether there's any work around for this rather applying patch as suggested in metalink note 1397385.1.
> >> Aug 15 2012 22:00:36 ORA-12012: error on auto execute of job 183631
> >> Aug 15 2012 22:00:36 ORA-00001: unique constraint
> >> (SYS.WRI$_ADV_SQLT_PLANS_PK) violated Aug 15 2012 22:00:36
> >> ORA-06512: at "SYS.PRVT_ADVISOR", line 2693 Aug 15 2012 22:00:36
> >> ORA-06512: at "SYS.DBMS_ADVISOR", line 241 Aug 15 2012 22:00:36
> >> ORA-06512: at "SYS.DBMS_SQLTUNE", line 772 Aug 15 2012 22:00:36
> >> ORA-06512: at line 4
Anyone face similar issues?
thanks
Pradeepa
SQL> select distinct(sqlset_name) from dba_sqlset_statements;
SQLSET_NAME
------------------------------
SQLACCESS4347407_sts
SQLACCESS3615502_sts
SQL> SELECT sql_id, sql_text, sqlset_owner, sqlset_name
0