cpu utilization on a V class

[Amir Fadaghi]

Hello hp-ux gurus,

I have a V class server that I am using it as a database server. It has 4 cpus and runnig 4 oracle databases. When I do the "top", only the 4th CPU shows over %99 utilized. Anything I can do to make all the cpus utilized? I have attached the word document print screen of the display. I appreciate any help.

[G. Vrijhoeven]

Hi,

You do not have to change a thing in UNIX because it will distibute the load equally over the CPU's as long as the application/query supports that. It must be Multy Threaded. I Think a DBA should be able to help you.

Gideon

[Jeff Schussele]

Hi Amir,

As Gideon has pointed out, unless the binary is multi-threaded, it will run on only one processor.

Rgds,
Jeff

[Paula J Frazer-Campbell]

Hi

The points about threads have been said but what is oracleGOLDQA doing to consume 98.94%? Get your DBA to have a look as well as using TUSC to have a lookj at it yourself.

Paula

[doug mielke]

As mentioned, an application has to be multi threaded to take advantage of multiple CPUs.
OS processes, and additional Oracle processes will be assigned to other processors ( as shown in your top output)

However, I'd want to ensure that the 1st process listed in the top output is not misbehaving for some reason. (index problem, hung connections, etc)
It seems unusual for that porcocess to consume so much, and have it's priority raised to that level.