Re: CPU > Elapsed

From: Brian Peasland <oracle_dba_at_peasland.com>
Date: Thu, 26 Sep 2002 18:16:45 GMT
Message-ID: <3D934F0D.7B1FC1B1@peasland.com>

I have seen some suggestions from others that the CPU timing isn't always exact due to rounding errors on certain platforms (can't remember which) and that CPU times in these cases can exceed Elapsed times.

HTH,
Brian

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
Received on Thu Sep 26 2002 - 13:16:45 CDT