How to read the result of TKPROF

[ligang]

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.
********************************************************************************

[marist89]

Originally posted by ligang

Does it mean that the total sql execution time is
elapsed(NON-RECURSIVE)+elapsed(RECURSIVE) = 2.96 +0.28=3.24 sec?

It means the database spent 3.24 seconds working on it. However, your session may have been connected longer and waiting for the client. Oracle 9i (9.2 at least) has a section of tkprof that shows what you were waiting on. I suggest you use that.

[ligang]

Is it possible to tell what option should be used in TRPROF to display the waiting time?

We are using oracle9.2 above

[waitecj]

Try set events 10046 level 12 and use Trace Analyzer whilst contected as the person who created the trace file.