topic Re: Limit CPU Usage Per Process in Operating System - HP-UX

Limit CPU Usage Per Process

Md. Minhaz Khan — Mon, 22 Feb 2010 07:50:49 GMT

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

Re: Limit CPU Usage Per Process

Johnson Punniyalingam — Mon, 22 Feb 2010 08:02:26 GMT

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

Are you facing any "High Cpu" usage ??

Re: Limit CPU Usage Per Process

Md. Minhaz Khan — Mon, 22 Feb 2010 09:03:56 GMT

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

Re: Limit CPU Usage Per Process

Dennis Handly — Mon, 22 Feb 2010 09:21:57 GMT

>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?

Re: Limit CPU Usage Per Process

Johnson Punniyalingam — Mon, 22 Feb 2010 09:30:50 GMT

>>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 ?/

Re: Limit CPU Usage Per Process

WayneHP — Mon, 22 Feb 2010 13:36:36 GMT

What are your oracle processing wait on?

Use glance.

Re: Limit CPU Usage Per Process

Bill Hassell — Mon, 22 Feb 2010 19:59:38 GMT

> 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?

Re: Limit CPU Usage Per Process

Md. Minhaz Khan — Tue, 23 Feb 2010 09:29:19 GMT

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

Thanks
Minhaz