How to read the result of TKPROF
We are trying to figure out some performance issue .
This is the summary from trprof
Does it mean that the total sql execution time is
elapsed(NON-RECURSIVE)+elapsed(RECURSIVE) = 2.96 +0.28=3.24 sec?
********************************************************************************
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 310 0.20 2.59 0 0 0 0
Execute 310 0.11 0.35 0 246 447 142
Fetch 96 0.00 0.00 0 538 0 157
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 716 0.31 2.96 0 784 447 299
Misses in library cache during parse: 92
OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 145 0.05 0.25 0 0 0 0
Execute 145 0.03 0.02 1 146 442 145
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 290 0.08 0.28 1 146 442 145
Misses in library cache during parse: 5
310 user SQL statements in session.
145 internal SQL statements in session.
455 SQL statements in session.
********************************************************************************
1. www.dbasupport.com
2. www.dbforums.com
3. www.itpub.net
4. www.csdn.net
5. www.umlchina.com
6. www.tek-tips.com
7. www.cnforyou.com
8. fm365.federal.com.cn
9. www.programmersheaven.com
10.http://msdn.microsoft.com/library/default.asp
ligang1000@hotmail.com