Re: how to drop all sql plan baselines

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Thu, 11 Sep 2014 14:56:06 -0500
Message-ID: <CAEueRAUU2S+B2rRuRh+CqwyDRLsUPfegmLRZn4upMeN2BFysMw_at_mail.gmail.com>

I've seen these errors after upgrade before. In my experience it has always been a sql statement with either an unqualified column reference that exists in more than one of the joined tables, or a column name or alias is now a reserved word and needs to be quoted.

Have you isolated the sql statements throwing this error?

Seth Miller

On Thu, Sep 11, 2014 at 2:24 PM, April Sims <aprilcsims_at_gmail.com> 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_at_gmail.com
>

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

Received on Thu Sep 11 2014 - 21:56:06 CEST