CPU > Elapsed

From: Fan Ruo Xin <fanruox_at_sbcglobal.net>
Date: Thu, 26 Sep 2002 03:46:39 GMT
Message-ID: <3D9282E5.F700E0B0@sbcglobal.net>

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 Wed Sep 25 2002 - 22:46:39 CDT