| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 100% CPU
Cary,
That's a very good addition to the analogy. Of course I guess it depends on whether we are talking about a house (server) with multiple water supplies (cpu's) or not. And of course we aren't talking about running at 100% 24x7... Just when the bath needs to be filled.
"Cary Millsap"
<cary.millsap_at_hot To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
sos.com> cc:
Sent by: Subject: RE: 100% CPU
root_at_fatcity.com
20/05/2003 15:41
Please respond to
ORACLE-L
I agree with your water analogy, but an interesting point to consider is a potential benefit of filling the tub slowly. Imagine that one of your requirements is to have a reserve of water on supply so that you could quickly fill a gallon jug on demand without causing the person waiting on the bathtub to perceive that any water had been diverted from filling the tub...
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101 in Reykjavik, Ottawa, Dallas, Washington, Denver,
Sydney
- Visit www.hotsos.com for schedule details...
-----Original Message-----
Sent: Monday, May 19, 2003 11:47 PM
To: Multiple recipients of list ORACLE-L
In defence, it's not the spinning disk but the head flying all over the disk which is likely to fail from over use.
Having said that I'm a big proponent of using available hardware. Hardware is a commodity to be used, not protected and viewed from a distance. If I wear a harddisk out sooner because I've done lots of work with it then that's fine.
Performing an item of work is a bit like filling a bathtub with water in this sense. I can turn the tap on fast and fill it quickly, or just turn it on a little bit and fill it slowly. Which approach uses more water? Neither. Which gets the job done quicker? The first option. What's the benefit of the second option? Nothing really - unless you like the sound of running water.
Note: There is a big difference between 100% utilisation and inefficient use... I hate inefficient use. :-)
"Deshpande, Kirti"
<kirti.deshpande_at_v To: Multiple
recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
erizon.com> cc:
Sent by: Subject: RE: 100% CPU
root_at_fatcity.com
20/05/2003 13:31
Please respond to
ORACLE-L
Sorry, but I thought the Hard Disks inside the disk arrays spin all the time. So, are those wearing out faster?
-----Original Message-----
Sent: Monday, May 19, 2003 9:27 PM
To: Multiple recipients of list ORACLE-L
>From: Mladen Gogala <mgogala_at_adelphia.net>
>Subject: Re: latch free - library cache
>
>So, what is spending the CPU? Why is a CPU running pedal to the medal a
>problem?
>I thought that CPU hardware was bought in order to run and not to sit
idle?
>The same goes for the memory. There are some people, mostly known as sys
>admins
>that will try telling you that "we need to keep CPU / memory N
>0.000000ree". Well,
>hardware is bought to be utilised. Nobody will stop a CPU for speeding
>(unlike myself and my passion for speeds above 80mph). CPU running at 100
>0s not a problem. An application not performing adequately is a problem.
Someone telling you that the cpu should be at zero percent is just being
silly, however running at 100% is not an optimum condition. As one of the
evil Sys Admins that you mentioned, I personally prefer my servers to not
go
over 30% utilization on average, and prefer spikes to stay under 70%. If
your hardware is running full bore all the time, two things will happen 1)
Your hardware will wear out faster, especially hard drives, and 2) Your
users will notice a slowed response time and complain. I'd say any server
that runs over 50% usage on a regular basis is probably a good candidate
for
either an upgrade or some load balancing. These figures can vary some with
your budget and business needs but as a generic rule I think many peopel will agree with me in principle. Besides, if you're running at 100% during
normal usage, what happens when a spike comes along like a shift change? Your server is going to lag, and users will be affected.
Chris Berry
compjma_at_hotmail.com
Systems Administrator
JM Associates
"What does it mean when they tell you your budget and it's a negative number?"
_
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: kirti.deshpande_at_verizon.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>Received on Tue May 20 2003 - 01:36:35 CDT
>>>>
Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: mrichard_at_transurban.com.au Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: cary.millsap_at_hotsos.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: mrichard_at_transurban.com.au Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
 |
 |