Databases
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