Performance Issues

[xcvzxvzxdv]

I need help on performance issues that are coming in my server. When I issue top command the systems in 0.0 % idle. Howver if I see at the processes the CPU consumption is less than what I is it showing in avg of TOP. I am sending the output of TOP command.

I am not getting which processes are utilizing the CPU power and that are not getting displayed even with TOP command

[Arunvijai_4]

Hi,

Sometimes, top doesnt help you. You can try the following,

1) UNIX95= ps -ef -o cpu,pcpu,pid,comm

Execute this and see what is happening in your system.

2) http://www.hpux.ws/system.perf.sh


-Arun

[Warren_9]

hi,

from the top output, I think the "post_rate" used most of the CPU esource....

u can also use ps to list the %CPU and sort it.
UNIX95= ps -ef -opcpu,pid,ppid,ruser,args|sort -k1

GOOD LUCK!!

[xcvzxvzxdv]

Thanks for ur reply.

Post _rate processis utilizing most of CPU power and that what is expected.

3-4 Days before we were running four strams of post_ rate and each was utilizing 80-90% However now suddenly I dont know what has happened and it is utilizing only 40-50 %.

I am sending you the output of the commands u have given. But still I am unable to get where my cpu power is going. Kindly help me on this

[Frank de Vries]

It seems that these process where cpu hungry,
I presume they run on Oracle 9i.


19.89 14337 12105 bsnlprod post_rate SWITCH=MH PERSPECTIVE=INCOM
24.00 2529 1528 bsnlprod post_rate PERSPECTIVE=INCOM SWITCH=MPCHG
28.64 14108 14103 root compress /user_sun/oracle9i/oradata/iobasprd/archive/archive_30
29.28 11243 1 oracle9i oracleiobasprd (LOCAL=NO)
42.90 2340 1528 bsnlprod post_rate PERSPECTIVE=INCOM SWITCH=GJ
54.02 1775 1528 bsnlprod post_rate PERSPECTIVE=INCOM SWITCH=WTR

Try to find out if the are doing something on the OS or if they are doing something in
Oracle.

Maybe you can check in the v$sqlarea
to find the number of blocks read/write
for these processses :

select s.username, s.sid, s.machine, s.osuser, n.statistic#,
substr(s.program,1,25),
t.value "Aantal reads - writes"
from v$session s, v$sesstat t, v$statname n
where s.sid = &SID_FROM_PID
and s.sid = t.sid
and t.statistic# = n.statistic#
and n.name like '%physical%'
and not s.username is null

You can find &SID_FROM_PID,
by querying v$process against v$session first.

[xcvzxvzxdv]

yes we have oracle 9i installed , and post rate is the process which pusses the data in the Oracle 9i.

[Warren_9]

hi,

as you can see from the top, the nice value of the post_rate is 24, therefore those processes have lower priority than others.

the %CPU drop may due to other processes which have higher priority... like the "oracleiobasprd"

reset the nice value of the post_rate may help.

GOOD LUCK!!