RE: Oracle 10g upgrade - performance issue

RULE hint is officially desupported by Oracle, but 10.2.0.2 will still obey it - I've used it effectively on a problem query that I posted about recently where the query was taking 15 seconds to parse in 10g compared to < 1 second in 8.0.6.

Stored outlines, (a.k.a. plan stability) work very well in my experience
(although I'm sure there are some bugs that I've just been lucky enough
to avoid so far). I would recommend them for the proper situations
(when all else fails) - I've implemented it a number of times in 9iR2
and 10gR2 - let me know if you have trouble getting it to work and I may be able to help.

Regards,
Brandon Allen

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Laimutis Nedzinskas Sent: Wednesday, July 12, 2006 5:15 AM
To: oracle-l_at_freelists.org
Subject: RE: Oracle 10g upgrade - performance issue

First of all - 10r2 does not support rule hints, does it?

Another approach is try to play wiht plan stability, i.e. outlines. I was not very impressed, i.e. it did not work for me. It worked for one simple test SQL but for a real 100 row explain plan it failed. May be I've done something wrong but Oracle official and unofficial(not supported) documentation is rather little, Oracle engine says nothing why it accepts or not accepts outline recommendation. The are mixed opinions how it works for literal sql and cursor_sharing=force.         

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