Hi,

What is the difference between the CPU time and the Elapsed time as
seen in the TKPROF results?

Thanks,
Santosh

I don't know what TKPROF is, but:

CPU time is the time that the CPU was doing job for you. Elapse time is the amount of time from
start of processing to end of processing. During this period, the CPU could have done things for
somebody else.

Show quoteHide quote

CPU time is how much time the CPU spent actually doing work.  Elapsed time
is total time... not all of your time was necessarily spent doing CPU work,
it could have been waiting on other tasks, it could have spent time in I/O
(reading/writing to disk) or bandwidth...

What on earth is TKPROF?  (I don't really need to know the answer, that was
bordering on rhetorical...)

Hi Santosh

Although the explainations posted by others are probably still valid, you
may want to post this to an Oracle newsgroup!

John

<j.santosh.she***@gmail.com> wrote in message
Show quoteHide quote

Evaluation of conditions
complex and large triggers
Apostrophes and Dynamic SQL
Table design question on LARGE table
Query help