RE: Seeking advice on potential 10g upgrade

With all due respect I have to disagree with you on that. In many cases hints can make query execution more stable. After all - Oracle's own "Plan Stability" feature (a.k.a Stored Outlines) is really just a bunch of persistent internal hints. So, it depends on what hints are used, but if they are just simple index and join method hints - they might actually make things more stable/predictable through an upgrade.  

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kevin Closson
> Sent: Monday, August 28, 2006 11:56 AM
> To: oracle-l_at_freelists.org
> Subject: RE: Seeking advice on potential 10g upgrade
>
> >>>I know that they have made liberal use of optimizer
> hints, and I'm afraid that those may cause us grief if we upgrade.
>
> ...that's a good bet.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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