Re: how to drop all sql plan baselines
- From: April Sims <aprilcsims@xxxxxxxxx>
- To: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 11 Sep 2014 15:22:38 -0500
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
>
>
> On Thu, Sep 11, 2014 at 2:46 PM, April Sims <aprilcsims@xxxxxxxxx> wrote:
>
>> Chris,
>>
>> I have dropped all profiles and baselines that I could find related and
>> still the error persists.
>>
>> On Thu, Sep 11, 2014 at 2:41 PM, Chris Taylor <
>> christopherdtaylor1994@xxxxxxxxx> wrote:
>>
>>> 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
>>>>
>>>
>>>
>>
>>
>> --
>> 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
>>
>
>
--
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:
