Oracle processes only using one CPU

[Alan Casey]

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.

[Dirk Wiedemann · Accepted solution]

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]

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.

[Justo Exposito]

Hi Alan,

We are from AXA Spain.

Justo.

[Alan Casey]

Thanks everyone

[T G Manikandan]

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