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

Different clocks are used (eg + = tick)

event XXXXXXXXXXXXX
cpuclock --------+--------+--------+--------+ elapsed --+--------+--------+--------+--------+

Thus: cpu = 2, elapsed = 1

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."