diff between CPU time and elapsed time?

Hi,
What is the difference between the CPU time and the Elapsed time as
seen in the TKPROF results?
Thanks,
SantoshI 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.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<j.santosh.shenoy@.gmail.com> wrote in message
news:1135847807.311256.275360@.g44g2000cwa.googlegroups.com...
> Hi,
> What is the difference between the CPU time and the Elapsed time as
> seen in the TKPROF results?
> Thanks,
> Santosh
>|||> What is the difference between the CPU time and the Elapsed time
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...

> as seen in the TKPROF results?
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.shenoy@.gmail.com> wrote in message
news:1135847807.311256.275360@.g44g2000cwa.googlegroups.com...
> Hi,
> What is the difference between the CPU time and the Elapsed time as
> seen in the TKPROF results?
> Thanks,
> Santosh
>sql