topic Re: Oracle processes only using one CPU in Operating System - HP-UX

Oracle processes only using one CPU

Alan Casey — Wed, 04 Sep 2002 07:43:28 GMT

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.

Re: Oracle processes only using one CPU

Dirk Wiedemann — Wed, 04 Sep 2002 09:05:03 GMT

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

Re: Oracle processes only using one CPU

Justo Exposito — Wed, 04 Sep 2002 09:35:02 GMT

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.

Re: Oracle processes only using one CPU

Justo Exposito — Wed, 04 Sep 2002 09:36:07 GMT

Hi Alan,

We are from AXA Spain.

Justo.

Re: Oracle processes only using one CPU

Alan Casey — Wed, 04 Sep 2002 10:05:45 GMT

Thanks everyone

Re: Oracle processes only using one CPU

T G Manikandan — Wed, 04 Sep 2002 10:07:54 GMT

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