Re: Seeking advice on potential 10g upgrade

I'd take a look at http://www.jlcomp.demon.co.uk/hinted_sql.html for some further discussion of whether the system is likely to be more stable or run into issues in the presence of many hinted sql statements.

Plan Stability is indeed a set of hints, its the main evidence that I use when I state that a hint is a directive, rather than a 'hint' in the english sense of the word, it's worth noting however the number of hints that Plan Stability tends to find necessary to produce a locked in execution plan, and compare to the typical use of hints by developers. for example many developers would write code like

select
/*+ USE_NL(a,b) */ <cols>
from
a, b
where <criteria>

and consider that this ensured that Oracle would use a nested loops join for the query.

On 8/28/06, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
> 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
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l