High NICE value in TOP

[Eric Lemmers]

Hi,

On a system connected by SAN to an HDS 9570 I'm having performance problems on my Oracle database. Looking at TOP I see very high NICE values, like these..

133 processes: 128 sleeping, 4 running, 1 zombie
Cpu states:
CPU LOAD USER NICE SYS IDLE BLOCK SWAIT INTR SSYS
0 0.08 0.0% 0.0% 0.0% 100.0% 0.0% 0.0% 0.0% 0.0%
1 0.26 0.0% 64.5% 4.6% 30.9% 0.0% 0.0% 0.0% 0.0%
2 0.13 0.0% 0.2% 0.0% 99.8% 0.0% 0.0% 0.0% 0.0%
3 0.19 0.0% 0.0% 0.0% 100.0% 0.0% 0.0% 0.0% 0.0%
--- ---- ----- ----- ----- ----- ----- ----- ----- -----
avg 0.17 0.0% 16.2% 1.2% 82.6% 0.0% 0.0% 0.0% 0.0%

Memory: 973904K (711136K) real, 1197560K (838952K) virtual, 861544K free Page# 1/9

CPU TTY PID USERNAME PRI NI SIZE RES STATE TIME %WCPU %CPU COMMAND
1 ? 1436 raadpopr 149 21 815M 145M sleep 50:20 59.70 59.60 oracleP741


with sar I can see there is little throughput

Is this just an I/O bottleneck ??

Please help.

Eric Lemmers

[Yogeeraj_1]

hi Eric,

check whether the "raadpopr" process is not a run-away process.

this snap shows that it is consuming a high amount of CPU (of cpu no 1) and memory

Note that you may also use glance to further drill-down on this process.

kind regards
yogeeraj

[Eric Lemmers]

Hi yogeeraj,

The funny thing is that after a while the high NICE values are gone for some time and with sar I can see up to 60.000 to 80.000 blks/s throughput.
In other words 'it comes and goes'.

Eric

[Yogeeraj_1]

hi Eric,

did you run a statspack report?

if you are running Oracle 10g, the ADDM (utomatic database diagnostic monitor) will be awesome...

Also, if you have mwa, you can extract your performance data and plot appropriate graphs to identified the periods during which you have having these problems.

hope this helps!

kind regards
yogeeraj

[Chan 007]

Eric,

This scrit is very handly and SEP has provided this one. Just use it that will help you a lot.

From what i see from your top is, you don't have a IO problem (SAN) related. Just use vmtast, swapinfo to drill a bit. I also recon you to check the Kernel param.

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

Chan