Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Seeking advice on potential 10g upgrade

RE: Seeking advice on potential 10g upgrade

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Mon, 28 Aug 2006 11:43:03 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C45059E1DDB@NT15.oneneck.corp>


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: Bjrn Drr Jensen [mailto:B.D.Jensen_at_gmx.net] 
	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_at_OneNeck.com>  
		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.

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 28 2006 - 13:43:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US