CPU_TIME Vs ELAPSED_TIME

[engineer2100]

I have run through a lot of articles on these columns but none gave me satisfactory explanation.

Could one of you provide me with the same?

Thanks
Engi

 

[Dagon]

elapsed_time = total time required by the query.

cpu_time = time the processor(s) have spent on your query (the rest of the time the processor may be working on another task or sitting idol while it is waiting for an I/O operation to complete).

cpu_time will always be less than elapsed_time.

 

[KenCunningham]

Nice one Dagon. Is cpu idol similar to American Idol? ;-)

I want to be good, is that not enough?

 

[Dagon]

Yes, lots of CPUs have to run processor-intensive jobs in front of a panel of judges. The judges make mocking comments about the performance and then the public votes them off one by one.

Slight misprint. Should have said "CPU idle", of course.

 

[SantaMufasa]

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]