why the difference between clock time and sql trace time.

following is a list from sql_trace tkprof from tracing a procedure. The procedure ran about 90 minutes clock time. 90 x 60 = 5400 sec

total cpu and elapsed time by adding all cpu+elapse is less than 200sec. why.

thnx a lot
ted chyn

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse        1      0.01       0.02          0          0          0           0
Execute      1      0.00       0.02          0          0          0           0
Fetch        0      0.00       0.00          0          0          0           0


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

total        2      0.01       0.04          0          0          0           0

Misses in library cache during parse: 1
Misses in library cache during execute: 1

OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse      158      0.29       0.29          1        128          1           0
Execute  69749      6.87       5.02          1        156       8430        7686
Fetch    85937     32.00      46.24       3414     587930      30756       70052


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

total   155844     39.16      51.55       3416     588214      39187       77738

Misses in library cache during parse: 35 Misses in library cache during execute: 1

   12 user SQL statements in session.
  148 internal SQL statements in session.   160 SQL statements in session.
   10 statements EXPLAINed in this session. Received on Thu Sep 20 2001 - 23:20:21 CDT