Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: CPU > Elapsed

Re: CPU > Elapsed

From: Fan Ruo Xin <fanruox_at_sbcglobal.net>
Date: Fri, 27 Sep 2002 02:49:29 GMT
Message-ID: <3D93C6FF.B86F4CA0@sbcglobal.net>


Thanks, Brian & Connor!

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 - 21:49:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US