help with reading tkprof output

Under Oracle 10g (10.2.0.3.0)

I have a tkprof log.

The plan appears perfectly sensible,
and the fetch runs very rapidly.

The time for the "fetch" phase is nicely documented against the plan, with time in us for each part of the evaluation.

But all this detail applies to the "fetch".

Sadly, most of the user and elapsed time is going in "Excute":

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

Parse        1      0.01       0.00          0          0          0           0
Execute      1     12.91      12.61          0          0          0           0
Fetch        3      0.05       0.04          0       1634          0          26


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

total        5     12.97      12.67          0       1634          0          26

for which I have no "finer grained" information.

So; two questions;

what activities does tkprof group under "Execute" and how can I get finer grained information on them?

Thanks to all for any help provided.

   BugBear Received on Thu Nov 15 2007 - 06:06:03 CST