topic Re: Process Issues in Operating System - HP-UX

Process Issues

shruti_1 — Thu, 01 Jun 2006 01:30:24 GMT

Hi there is a process that we run called post_rate that pushes the data in the oracle. Since yesterday I don't know what has happened that process is taking jerks sometimes it is running at a very high rate and sometimes it runs at a very small rate.

From sar output I have found that this process takes as large as 90% of CPU utilization and as low as 0.16 of cpu utilization even if the cpus are sitting idle . Could anyone help me out on this

Re: Process Issues

Peter Godron — Thu, 01 Jun 2006 02:50:34 GMT

Hi,
is this the same machine as in your other problem? http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1031131

If so, then the problem might be that the oracle process is waiting for the disk to become available (0.16%) and then goes to 90%. Please correct my assumption by supplying more details.

Re: Process Issues

Raj D. — Thu, 01 Jun 2006 04:10:12 GMT

Shruti ,

You have to monitor the system performance over a period of time. And collect the sar output in non peak hours also using cron.
And you can come to know why this symptom is happening.

sar -u -M 5 10 > sarout_cpu.txt
And check if always one cpu is getting used for that process or any other symptom.

also check with vmstat 5 5 , glance , top.

also you must investigate with DBA , as what post_rate does actually.

Cheers,
Raj.

Re: Process Issues

shruti_1 — Thu, 01 Jun 2006 05:27:21 GMT

My issue has been resolved it was related to buffer cache.

One more question I have if there is a process that is running at say 90% cpu power is it possible to lower down its value to a larger extent say 10 % or so

Re: Process Issues

Peter Godron — Thu, 01 Jun 2006 05:31:11 GMT

Hi,
you can alter the PRIORITY of the job with renice.
See "man renice"

Re: Process Issues

shruti_1 — Thu, 01 Jun 2006 05:35:27 GMT

I have tried renice but it dont decrease the value to the larger extent is there any other method

Re: Process Issues

Peter Godron — Thu, 01 Jun 2006 05:45:53 GMT

Hi,
the only other method I know of is buying products such as:
Process Resource Management (PRM) or
Workload Manager

Re: Process Issues

shruti_1 — Thu, 01 Jun 2006 05:56:33 GMT

Are there any commands by which it can be done

Re: Process Issues

Peter Godron — Fri, 02 Jun 2006 06:37:39 GMT

Hi,
I don't think there are any online commands.
Also,please read:
http://forums1.itrc.hp.com/service/forums/helptips.do?#28