Re: CPU > Elapsed

Fan Ruo Xin wrote:

> I took a SQL Trace for one of my SQL scripts. From the TKPROF Output:
>
> Overall Totals for All recursive Statments:
> =============================
> Call Count CPU Elapsed
> Parse 1023 2.14 7.88
> Execute 1058 0.42 0.33
> Fetch 801 0.12 0.13
>
> I can't know why for the recursive statment the CPU time (0.42) >
> Elapsed time (0.33) during the Execute phase?
> TIA
> Rosaline

If U got more than one cpu, execute elapsed time can be less than cpu time spend. :-)

/Svend Jensen   Received on Thu Sep 26 2002 - 07:40:00 CDT