how to drop all sql plan baselines

From: April Sims <aprilcsims_at_gmail.com>
Date: Thu, 11 Sep 2014 14:24:14 -0500
Message-ID: <CAK+cZDcSGYgJAKR4+B9LxjrWAwCK5O4+Z3v4LDqLV2b2NAbO8g_at_mail.gmail.com>

I am in need of some urgent help....we upgraded to 11.2.0.4 from 11.2.0.3 and now getting a few ora-904 errors....which are considered production down.

We didn't see this in our pre-production environment. This is poorly written vendor code which CAN'T be modified. If we pull the sql from the ORACLE form and rewrite it, it no longer error outs with a 904.

I think it is related to dba_sql_plan_baselines. Should I remove all plans? Just disable them all....?? Anyone else see this behavior. It is not synonyms, permissions or the like.

I removed several plans which I though were related but that didn't fix it.

Flushed the shared pool..

thanks,

-- 
April C. Sims
IOUG SELECT Journal Editor
http://aprilcsims.wordpress.com
Twitter, LinkedIn
Oracle Database 11g – Underground Advice for Database Administrators
<http://www.amazon.com/Oracle-Database-Underground-Advice-Administrators/dp/1849680000/ref=sr_1_1?ie=UTF8&s=books&qid=1272289339&sr=8-1#noop>
https://www.packtpub.com/oracle-11g-database-implementations-guide/book
OCP 8i, 9i, 10g, 11g DBA
Southern Utah University
aprilcsims_at_gmail.com

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 11 2014 - 21:24:14 CEST