RE: SQL Traces' Comparison
Date: Mon, 18 Aug 2008 15:52:31 +0530
Message-ID: <69E1360E54B50C4A828A136C158E474204FE7A086C@BLRKECMBX02.ad.infosys.com>
Thanks V much Rakesh, Wolfgang for the Advice
Different Input Data & its respective skew in the Table was the cause of Different Elapsed Timings for the 2 Cases.
Cheers
-----Original Message-----
From: Rakesh Tikku [mailto:rakesh.tikku_at_gmail.com]
How about parameters/bind variable values passed to the program/sql?
Where they identical in both cases ?
Rakesh Tikku
From: Wolfgang Breitling [mailto:breitliw_at_centrexcc.com]
I advise to look at the raw trace in detail. Since tkprof summarizes all identical sql into one entry there is no guarantee that all 17 executions in CASE 2 used the same plan. tkprof simply uses the first execution plan in the trace for the summarized entry. If subsequent executions use a different plan you wouldn't know from tkprof. I'm not saying that that is the case here, but it is a possibility with a greater than zero probability.
At 11:10 AM 8/14/2008, VIVEK_SHARMA wrote:
Folks
For the same SQL with the same execution Path on the same Database, what is the possible cause for High Elapsed Time ub Case 2 (below)? NOTE - Table sizes having grown Slightly (by a few GB) in Case 2
...
Cheers & Thanks
P.S.
- CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 18 2008 - 05:22:31 CDT