Oracle on multiprocessor box

[mart1]

Hi all,

I am runnning Oracle 8.1.7 On a 4 processors SP Node (AIX 4.3.2).
I discovered today that the load was no spread accross the processors. When i do a vmstat (With a parallel sort running), The user load is about 25 % (75 %idle). For me it means that only one processor is used. But oracle shows 4 threads running.
The oracle DBS sees the 4 processors but does not seem to use it.
I have checked on some other systems (2 processors only) and it looks the same.

1) Is it normal for Oracle to use only one processor ?
2) And if not, how do you make Oracle uses all the processors ?

Any one have an idea ??

Martin (AIX and Databases admin).

 

[Yegolev]

I have never see this but I say if Oracle is only consuming 25% CPU you are quite lucky. I think maybe gheist is right and we have no problem because we overflow a single CPU rather easily. We are running 4.3.3.0-09 and mostly Oracle 8.1.7 of various levels, mostly .2-.4. As far as I know we have not had to explicitly run bindprocessor. IBM Certified -- AIX 4.3 Obfuscation

 

[devyfong]

Now the AIX4.3.3 ML is ML10;
By the way,You can monitor the CPU with the follow command:
#sar -P ALL 5 100
This will give you all processor usage and the average value.

Good luck!