RE: SQL Traces' Comparison
- From: VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx>
- To: Rakesh Tikku <rakesh.tikku@xxxxxxxxx>, "breitliw@xxxxxxxxxxxxx" <breitliw@xxxxxxxxxxxxx>
- Date: Mon, 18 Aug 2008 15:52:31 +0530
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@xxxxxxxxx]
How about parameters/bind variable values passed to the program/sql?
Where they identical in both cases ?
Rakesh Tikku
________________________________
From: Wolfgang Breitling [mailto:breitliw@xxxxxxxxxxxxx]
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***
Other related posts:
