RE: Need help on query performance issue
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 planand 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 inproduction 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-lReceived on Thu Oct 01 2009 - 09:39:25 CDT