Re: *Measuring sql performance (elapsed time and scalability) by number of logical reads

> response time (elapsed time) = service time + wait time.
>
> as an aside, note that there are no counts anywhere in that formula. In
> your
> case the service time (cpu) is the difference. Due to the peculiarities of
> cpu
> time accounting, wait time is -0.01 for both of your queries, but plan 1
> takes 4
> times the cpu to do the work.

Is there a way to get information about how (calls to hash function or something else) service time (CPU) is used up ? Something that makes clear the difference between the two fetch actions.

Fetch        2      0.26       0.25          0       1725          0  1
Fetch        2      0.06       0.05          0       7559          0  1

Thanks,
Dimitre

--
http://www.freelists.org/webpage/oracle-l