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

Other related posts: