Re: how to drop all sql plan baselines
- From: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
- To: April Sims <aprilcsims@xxxxxxxxx>
- Date: Thu, 11 Sep 2014 15:26:47 -0500
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@xxxxxxxxx> 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@xxxxxxxxx> 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
>>
>>
>>
>>
Other related posts: