Tkprof result reading

I know "query" column in the tkprof output means buffer gets. But I don't know the difference between execute and fetch. Can someone please explain it ? And why would my elapsed time smaller than CPU time in this case ?

Here is an example:

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

Parse        1      0.02       0.00          0          0          0           0
Execute   3003      0.88       0.70          3      30030          0           0
Fetch     3003      0.13       0.20          2       3003      12012        3003


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

total     6007      1.03       0.90          5      33033      12012        3003

Can someone explain the difference between execute (30030) and fetch (300) in this case and what exactly do they mean ?

Thanks.

-Bass Chorng Received on Mon Jun 25 2001 - 14:45:29 CDT