4 Replies Latest reply: Feb 17, 2010 6:53 PM by 734699 RSS

    elapsed time from tkprof

    734699
      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??