Re: how to drop all sql plan baselines
- From: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
- To: April Sims <aprilcsims@xxxxxxxxx>
- Date: Thu, 11 Sep 2014 14:41:57 -0500
Have you checked DBA_SQL_PROFILES to see if any are enabled that would
affect your specific SQLIDs that are failing?
If so, use dbms_sqltune and disable the profiles.
(I'm just throwing that out there because I remember a sql profile
generating either that error or a related error and we had to drop and
recreate the profile)
Chris
On Thu, Sep 11, 2014 at 2:24 PM, April Sims <aprilcsims@xxxxxxxxx> wrote:
> 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@xxxxxxxxx
>
Other related posts:
