RE: question about cpu usage
- From: ryan_gaffuri@xxxxxxxxxxx
- To: "Gogala, Mladen" <Mladen.Gogala@xxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 22 Oct 2004 20:57:15 +0000
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:
--
//www.freelists.org/webpage/oracle-l
Other related posts:
