Re: Parse/Exec./Fetch 'count' interpretation in tkprof output file

I would agree with your calculations:

i.e.

((2262849+502)*4096)/4 = 9,270,685,696/4 => Approx 2Gb per execution.

It just so happens that Oracle has fetched the 2GBytes in 2 'array' fetches per execution.

Why don't you run tkprof with "aggregate=no". That way you will see the stats for each individual execution (and then prove one way or the other).

There is a big discrepency between Elapsed Time (509.93 secs) and CPU Time (87.40 secs). There are no wait events listed in your post, but I suspect that a large majority of the overall elapsed time was spent waiting for the 103,180 physical I/O operations.

I would concentrate on the waits rather than the logical reads, since your wait time is about 85% of total elapsed time.

Matt Received on Fri Dec 02 2005 - 07:58:54 CST