Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle - number of CPUs changing on the fly

Erik Trolle
Occasional Visitor

Oracle - number of CPUs changing on the fly

How will Oracle react to the number of CPUs changing on the fly? This feature will be part of virtual partitions in HP-UX.
With 1 CPU, Oracle will not spin on a lock. With >1 CPU Oracle will spin on a lock. So changing from 2 to 1 CPU may have performance impact. Otherwise I would expect no problems.
Has anyone actually tried it out?

2 REPLIES

Re: Oracle - number of CPUs changing on the fly

Sounds to me like the sort of question you should actually bounce off of Oracl ethemselves.
My house is the bank's, my money the wife's, But my opinions belong to me, not HP!
Andreas D. Skjervold
Honored Contributor

Re: Oracle - number of CPUs changing on the fly

Hi
You will get a performenc boost if your procesess today does a lot of waiting to aquire latches.
If this isn't the case (as it was in my case), adjusting the spin_count parameter had no effect.
Do not increase the spin_count parameter if your already high on CPU usage.

Another thing is the fact that your computer gets extra CPU cylces for all other task. And that might speed things up a bit.

Or else you can just run a seti@home client on it... (just kidding)

Andreas

Only by ignoring what everyone think is important, can you be aware of what everyone ignores!