Home » RDBMS Server » Server Administration » is CPU insufficient ?
is CPU insufficient ? [message #220371] Tue, 20 February 2007 07:39 Go to next message
Messages: 9
Registered: December 2005
Location: St. Petersburg
Junior Member

Is it possible to see from the AWR-report - is CPU insufficient or no?
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
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?
Re: is CPU insufficient ? [message #220809 is a reply to message #220764] Thu, 22 February 2007 04:06 Go to previous message
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
Previous Topic: Oracle shared memory Realm does not exists
Next Topic: automatich startup linux reboot
Goto Forum:

Current Time: Sat Oct 22 00:40:15 CDT 2016

Total time taken to generate the page: 0.12422 seconds