Home » RDBMS Server » Performance Tuning » about add more cpus..
about add more cpus.. [message #261963] Fri, 24 August 2007 03:42 Go to next message
hot3b3c
Messages: 8
Registered: July 2007
Junior Member
Dear All:
Our database version is 8.1.7 for IBM AIX5L,
we add cpus from 4 processor to 8 processor.
Does any parameter need to modify?

Re: about add more cpus.. [message #261968 is a reply to message #261963] Fri, 24 August 2007 04:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Nothing to do if you didn't hard-code parallelism degree.

Take care that doubling the number of processors does not necessarily means halfing the response time, it can make things worse.

Regards
Michel

[Edit: one word missing]

[Updated on: Fri, 24 August 2007 06:13]

Report message to a moderator

Re: about add more cpus.. [message #261991 is a reply to message #261968] Fri, 24 August 2007 05:25 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
It can make things MUCH worse.

Why are you increasing the number of processors?
Have you identified that you are currently CPU bound?
Previous Topic: Baby Tuning !!!
Next Topic: DBMS_APPLICATION_INFO Usage
Goto Forum:
  


Current Time: Tue Nov 26 22:26:56 CST 2024