This discussion is archived
4 Replies Latest reply: Feb 17, 2010 4:53 PM by 734699 RSS

elapsed time from tkprof

734699 Newbie
Currently Being Moderated
hi all,
i want to ask about elapsed time for query using sql trace,i'm reading about elapsed time.
elapsed time=cpu time+wait time

and this my result of tkprof
select * 
from
 equ_param_monitoringlist where id_equ_parameter=19 

call          cpu    elapsed       disk        rows
-------  -------- ---------- ----------  ----------
Parse        0.00       0.00          0           0
Execute      0.00       0.00          0           0
Fetch        0.60       2.26      10776      236383
-------  -------- ---------- ----------  ----------
total        0.60       2.27      10776      236383


Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                     319        0.00          0.00
  db file scattered read                        736        0.10          1.70
  SQL*Net message from client                   319        0.03          1.50
  SQL*Net more data to client                  1936        0.00          0.08
  db file sequential read                        51        0.01          0.04
 if elapsed time=cpu time+ wait time
elpased time=0.60+(1.70+1.50+0.08+0.05)
                 =0.60+3.32
                 =3.82
but elapsed time above is 2.27

so,what elapsed time is right??

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points