Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

General Questions


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.

11.2.0.2 update seems to have resolved this, fyi.


Related Links

List of DBA Tasks for configuring Configuration management database in ITIL
Oracle 7.3 to Oracle 9i
INSTR and INSTRB difference
which tables does V$SQL query?
standby database
Oracle 9i tutorials wanted
9i ODBC Drivers not showing up on XP Pro
whats the minimum memory for 10g R2 on Sun solaris ?
How can I detect database role BEFORE mounting database?
The ASM is unavailable, how to make it work?
Migrate a 100GB Database
Flashback Recovery area in Oracle 10g
Fetch the row with latest data,when multiple rows exist for same user
steps to create database link
Oracle GUI Admin Tools
How to add table to cluster and cluster index?