RE: Seeking advice on potential 10g upgrade

  • From: "Juan Miranda" <j.miranda@xxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 29 Aug 2006 10:11:43 +0200

I had some big problems with several querys when we change to 10g.
I must use optimizer_features_enabled.


-----Mensaje original-----
De: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] En
nombre de Allen, Brandon
Enviado el: lunes, 28 de agosto de 2006 21:24
Para: kevinc@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Asunto: 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@xxxxxxxxxxxxx 
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kevin Closson
> Sent: Monday, August 28, 2006 11:56 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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.
> --

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.



Other related posts: