Home » RDBMS Server » Server Administration » is CPU insufficient ?
is CPU insufficient ? [message #220371] Tue, 20 February 2007 07:39 Go to next message
AndreyPozhidaev
Messages: 9
Registered: December 2005
Location: St. Petersburg
Junior Member
Is it possible to see from the AWR-report - is CPU insufficient or no?

Report message to a moderator

Re: is CPU insufficient ? [message #220764 is a reply to message #220371] Wed, 21 February 2007 23:44 Go to previous messageGo to next message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
You should be able to see that on the system. I think sar -p 5 5?

Report message to a moderator

Re: is CPU insufficient ? [message #220809 is a reply to message #220764] Thu, 22 February 2007 04:06 Go to previous message
gintsp
Messages: 118
Registered: February 2007
Senior Member
I'd say that 100% CPU absolutely doesn't mean that one needs more CPU power. Most of the time it means that CPU power is used inefficiently and/or simply wasted. At least from my exprience every time when I observed very high CPU (speaking of DBs of course) it was due to:
1) excessive full scans (may very weel be also due to excessive use of index scans instead of full scans)
2) excessive parsing
3) doing unncessary looping in pl/sql

I think that nowadays at least for most DBs the main bootleneck is I/O (or should be I/O if code is properly written). Of course there may be exceptions Smile

Gints Plivna
http://www.gplivna.eu

Report message to a moderator

Previous Topic: Oracle shared memory Realm does not exists
Next Topic: automatich startup linux reboot
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 01:26:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.