Limit CPU Usage Per Process

[Md. Minhaz Khan]

Dear All,
In HP-UX we can limit memory usage per process by the kernel parameters maxdsiz_64bit,maxdsiz.

My query is how can we limit CPU usage per process in HP-UX??

Thanks
Minhaz

[Johnson Punniyalingam]

Check below thread, Comment from >>Bill<<
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=577509

Are you facing any "High Cpu" usage ??

[Md. Minhaz Khan]

Yes i have found high CPU usage. From the "top" command output i have found IDLE column is 0 (Zero) and Some oracle process eating above 30% CPU. This server is used as a "Data Werehouse" & lots of DML like insert,select, update query runs in this server.



Note: Our server model is RP4400 & it contains two dual core processor.

Thanks
Minhaz

[Dennis Handly]

>Some oracle process eating above 30% CPU.

You need more CPUs if you want to keep the same load on your system.
What do you think you'll achieve by limiting CPU usage per process?

Have you looked into PRM or WLM?

[Johnson Punniyalingam]

>>Some oracle process eating above 30% CPU. This server is used as a "Data Werehouse" & lots of DML like insert,select, update query runs in this server.<<<

Ok, well if lot of "query" run in the server.
you can check with "DBA Admin" why ?? does it cause eating above 30% cpu.

Does you "Kernal Settings" as per Oracle recommedations ?/

[WayneHP]

What are your oracle processing wait on?

Use glance.

[Bill Hassell]

> Yes i have found high CPU usage. From the "top" command output i have found IDLE column is 0 (Zero) and Some oracle process eating above 30% CPU. This server is used as a "Data Werehouse" & lots of DML like insert,select, update query runs in this server.

0% idle means that you aren't wasting any CPU cycles. If there were a way to limit the CPU cycles then Oracle will definitely run much slower. Is this what you wanted?

[Md. Minhaz Khan]

Thanks everybody to give me valuable suggestion.Now we decide to increase our CPU.

Thanks
Minhaz