SQL Traces' Comparison

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Thu, 14 Aug 2008 22:40:57 +0530
Message-ID: <69E1360E54B50C4A828A136C158E474204FE7A02DF@BLRKECMBX02.ad.infosys.com>

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

Will provide any detail needed

Cheers & Thanks

P.S.

CASE 1 Earlier

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse       24      0.01       0.00          0          0          0           0
Execute     36      0.05       0.03          0          0          0           0
Fetch       55      0.03       0.02          0       2099          0         374


------- ------  -------- ---------- ---------- ---------- ----------  ----------

total      115      0.09       0.06          0       2099          0         374

CASE 2 Later

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse       15      0.00       0.00          0          0          0           0
Execute     17      0.00       0.00          0          0          0           0
Fetch       17     30.30      91.66          0    3207424          0          68


------- ------  -------- ---------- ---------- ---------- ----------  ----------

total       49     30.30      91.66          0    3207424          0          68

**************** 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 Thu Aug 14 2008 - 12:10:57 CDT