Re: how to drop all sql plan baselines

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Thu, 11 Sep 2014 15:26:47 -0500
Message-ID: <CAP79kiTJp1hPxrfodM-BKQoAZV24yBM-F=Y+YYb4+9Te1t4yyQ_at_mail.gmail.com>

Yay! Glad I could help. Or as my coworkers would say, "Even a blind squirrel finds a nut once in a while!" ;)

Regards,

Chris

On Thu, Sep 11, 2014 at 3:22 PM, April Sims <aprilcsims_at_gmail.com> wrote:

> Chris,
>
> That did it....the second bug
> I disabled query rewrite
>
> HURRAH!
>
> Thanks so much.
>
> On Thu, Sep 11, 2014 at 2:57 PM, Chris Taylor <
> christopherdtaylor1994_at_gmail.com> wrote:
>
>> Have you checked the known issues with the 11.2.0.4 release?
>>
>> There's a couple but I don't know if they apply to your case or not:
>>
>> 17956707
>> <https://support.oracle.com/epmos/faces/DocumentDisplay?id=17956707.8> ORA-904
>> executing SQL over a database link
>> *19/May/2014*17551261
>> <https://support.oracle.com/epmos/faces/DocumentDisplay?id=17551261.8> ORA-904
>> "from$_subquery$_003".<column_name> with query rewrite*21/Feb/2014*
>>
>> Again, just throwing some thoughts out there.
>>
>> 11.2.0.4 Patch Set - Availability and Known Issues (Doc ID 1562139.1)
>>
>> Chris
>>
>>
>>
>>

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

Received on Thu Sep 11 2014 - 22:26:47 CEST