tkprof elapsed time

From: amonte <ax.mount_at_gmail.com>
Date: Wed, 21 Nov 2007 13:00:48 +0100
Message-ID: <85c1fb130711210400u7f404c66ld3eed4a741bbebbb@mail.gmail.com>

In a TKPROF output such as follows:

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

Parse        1      0.00       0.00          0          0
0           0
Execute   7045      8.68       8.72          0        156     159502
7045
Fetch        0      0.00       0.00          0          0
0           0

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

total 7046 8.68 8.72 0 156 159502 7045

Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 63

Elapsed times include waiting on following events:

  Event waited on                             Times   Max. Wait  Total

Waited

Waited ----------
log file sync 7045 0.04 33.33 SQL*Net message to client 7045 0.00 0.00 SQL*Net message from client 7045 0.04 4.66 log file switch completion 2 0.09 0.16

Is elapsed time = cpu time + waits? Because in this case we have 8.72 for elapsed time and 8.68 for cpu, log file sync waits is 33 seconds so shouldnt elapsed be around 42 seconds?

Or the elapsed time is calculated in a different way :-?

Alex

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 21 2007 - 06:00:48 CST