RE: Need help on query performance issue

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 1 Oct 2009 10:39:25 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A9046A8BD1_at_usahm208.amer.corp.eds.com>



Why is the Optimizer Mode=FIRST_ROWS? I this the production setting also?  

Where is the production explain plan for comparison purposes?  

What happens to the plan which is using a lot of full table scans since it is using hash joins if you change the optimizer mode to ALL_ROWS?    

  • Mark D Powell -- HP Enterprise Services Phone (313) 592-5148

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Shastry(DBA)

	Sent: Thursday, October 01, 2009 9:35 AM
	To: oracle-l
	Cc: Balakrishna Y
	Subject: Re: Need help on query performance issue
	
	
	Hi All/Balakrishna,
	
	Thanks for notifying it. Please find attached my explain plan
and the SQL script. Please help.         
	Reg,
	An
	
	
	On Thu, Oct 1, 2009 at 3:04 PM, Balakrishna Y
<krishna000_at_gmail.com> wrote:         

                Hi,                  

                There is no evidence for your question at all .... just post you query and statistics of your table & indexes ...                  

                Only then some one can help you out in this .                  

                Regards                  

                Bala                                   

                On 10/1/09, Shastry(DBA) <shastry17_at_gmail.com> wrote:

			Hi Gurus,
			I have Oracle query which runs fine in
production and test1 server but taking more time in the recently cloned two more dev servers. i checked for explain plan and got that two tables are having FULL TABLE SCANS and didnt find anything FTS issue in production and test1 servers with the same data. I did analyze two databases completely to have latest stats collection but didnt help :(.
			How to tackle this issue please guide.
			Thanks in advance.
			
			Reg,
			An
			




--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 01 2009 - 09:39:25 CDT

Original text of this message