Message-ID: <47600390.9040809@tufts.edu>
Date: Wed, 12 Dec 2007 10:51:44 -0500
From: Joe A-C <joseph.armstrong-champ@tufts.edu>
Organization: Tufts University
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
MIME-Version: 1.0
To:  oracle-l@freelists.org
Subject: Re: Wrong Results - Bad Execution Plan
References: <004b01c838ea$4d090a80$6701a8c0@itasoftware.com> <04DDF147ED3A0D42B48A48A18D574C450995AF30@NT15.oneneck.corp>
In-Reply-To: <04DDF147ED3A0D42B48A48A18D574C450995AF30@NT15.oneneck.corp>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: joseph.armstrong-champ@tufts.edu

We have also experienced a wrong results issue, too. The work around is 
to disable a 10g optimzer feature. I have heard of people running 10g 
who set optimizer_features_enable to a 9i setting in order to prevent 
performance issues. The idea is that if the app works well under 9i why 
change the optimizer. (If it ain't broke...) It seems like this might be 
a preventative action to take for wrong results issues, too. I'd be 
interested in knowing whether anyone has set the ofe to a lower version? 
What were the reasons and results?

Thanks.
Joe

Allen, Brandon wrote:
> Thanks for the update.  I just ran counts of the "wrong results" bug
> fixes in all patchsets from 9.2.0.2 to 10.2.0.4 and 10.2.0.4 is the
> highest by far with 180!  So, I think it's not just our imagination that
> the software is getting buggier as complexity increases (this was
> discussed in another thread recently).  Maybe Oracle will get to the
> point some day of offering a stripped down version for all of us that
> don't need the extra functionality and just want reliability and
> consistency.  Well, I guess we do still have the option of running
> 8.1.7.4 since it's under Lifetime Sustaining Support :-)
> 
> 
> -----Original Message-----
> From: oracle-l-bounce@freelists.org
> [mailto:oracle-l-bounce@freelists.org] On Behalf Of Henry Poras
> 
> There are a number of bugs listed in metalink associated with this
> feature (just search on _optimizer_filter_pred_pullup).
> 
> Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 
> 
--
http://www.freelists.org/webpage/oracle-l