RE: question about cpu usage

ok i will refine the question.
Assuming I am at a constant rate X of CPU usage, will there be a declining returns as CPU usage increases to X + n for a constant period of time.

Assume CPU usage holds steady. CPU u sage is CPU usage. It shouldnt matter what its doing in terms of performance. -------------- Original message --------------

> Question asked in such generality really doesn't make much sense and can
> only have one
> answer: it depends. Mostly, it depends on what is CPU doing. Well optimized
> queries will
> typically have a short burst or two of intense CPU activity and then will
> finish. Using
> 100% of CPU power is, unfortunately, also characteristic for "well cached"
> queries which
> can perform a gazillion logical block gets with no phyisical disk reads. An
> example of
> such query is the following:

--
http://www.freelists.org/webpage/oracle-l