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.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle processes only using one CPU

SOLVED
Go to solution
Alan Casey
Trusted Contributor

Oracle processes only using one CPU

Hi,

I have an A500 running Oracle 8.1.7 but the Oracle server processes only use one CPU. The server has 2 CPU's and this seems to be causing a bottleneck.

Does anyone know how to tell if this is an Oracle setting or something on the OS.
This is HP-UX 11.11 and as far as I know Oracle is not supposed to do this.
5 REPLIES
Dirk Wiedemann
Respected Contributor
Solution

Re: Oracle processes only using one CPU

Hello Alan,

I'm not an oracle specialist, but have a look at the HP Workload Manager under
http://resourcemanagement.unixsolutions.hp.com/WaRM/wlm/index.html
maybe this is helpful
Dirk
Justo Exposito
Esteemed Contributor

Re: Oracle processes only using one CPU

Hi,

Do you have a Oracle Parameter called CPU_COUNT and you can change it by using DBA Studio into this instance then Database then All initialization Parameters.

Hope this helps,

Justo.
Help is a Beatiful word
Justo Exposito
Esteemed Contributor

Re: Oracle processes only using one CPU

Hi Alan,

We are from AXA Spain.

Justo.
Help is a Beatiful word
Alan Casey
Trusted Contributor

Re: Oracle processes only using one CPU

Thanks everyone
T G Manikandan
Honored Contributor

Re: Oracle processes only using one CPU

Are both processors enabled on the machine.

You can use the GSP to check that

Just do a cntl-B
GSP>ss


Also use the sam -M option to check whether both cpu's are working


Thanks