Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: elapsed time less cpu time???
Looks good to me too... 1335 fetches in half a second cpu time...
The elapsed > cpu is just because of rounding errors, caused by a lot
(1335) of very short events. In the trace file you'll see a lot of
FETCH rows with e=0 i'd say...
Did you run the tkprof with waits=yes by chance?
jan Received on Fri Nov 14 2003 - 15:43:47 CST