RE: Seeking advice on potential 10g upgrade
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: Bjørn Dörr Jensen <b.d.jensen@xxxxxxx>, <janine@xxxxxxxxxx>, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 28 Aug 2006 11:43:03 -0700
I tried that parameter (at the suggestion of Oracle Support), but unfortunately
it didn't work in my case. I set it via ALTER SESSION rather than hint form,
but I would hope the effect is the same. A hint that I did find to work when
testing the queries manually was RULE - but unfortunately I can't add hints in
my application, so I had to use stored outlines instead.
Thanks,
Brandon
________________________________
From: Bjørn Dörr Jensen [mailto:B.D.Jensen@xxxxxxx]
Sent: Monday, August 28, 2006 11:05 AM
Hi!
We had an similar problem with some sql, where parse-time was multiple
seconds.
One of the 'solutions' (there must be a better way...) could be using:
select /*+ OPT_PARAM('_optimizer_cost_based_transformation' 'off') */
...
----- Original Message -----
From: Allen, Brandon <mailto:Brandon.Allen@xxxxxxxxxxx>
Sent: Monday, August 28, 2006 6:21 PM
I just did my first 10g production implementation about 2
months ago and it has been smooth sailing except for a couple of queries that
are performing outer joins of about 25 tables, which take 12 seconds to hard
parse in 10g compared to < 1 second on the 8.0.6 database we upgraded from. I
put in stored outlines to take care of this.
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:
