topic Re: cpu utilization on a V class in Operating System - HP-UX

cpu utilization on a V class

Amir Fadaghi — Mon, 22 Dec 2003 10:25:37 GMT

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.

Re: cpu utilization on a V class

G. Vrijhoeven — Mon, 22 Dec 2003 10:31:08 GMT

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

Re: cpu utilization on a V class

Jeff Schussele — Mon, 22 Dec 2003 10:34:08 GMT

Hi Amir,

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

Rgds,
Jeff

Re: cpu utilization on a V class

Paula J Frazer-Campbell — Mon, 22 Dec 2003 11:22:47 GMT

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

Re: cpu utilization on a V class

doug mielke — Mon, 22 Dec 2003 11:28:20 GMT

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.