Re: CPU > Elapsed

From: Fan Ruo Xin <fanruox_at_sbcglobal.net>
Date: Thu, 26 Sep 2002 12:34:41 GMT
Message-ID: <3D92FEA7.73A5CBFE@sbcglobal.net>

Svend Jensen wrote:

> 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. :-)
>

Thanks!
I do use a two CPU box to do the test. But I was using dedicated server process. And I didnot use parallel way.

Regards,
Rosaline

>
> /Svend Jensen
>
>
Received on Thu Sep 26 2002 - 07:34:41 CDT