Top cmd showing NICE value 97% -what to tune?

UNIX HP-UX
1

Running 2 VM Guests on an HPUX Integrity Server. One Guest runs great, the other is always at a high NICE value and 0% idle as shown in TOP:
What do you think should be tuned to bring down the NICE and increase IDLE %? Thanks in advance
-hpuxadmin

slow VM GUEST
 
Load averages: 2.56, 2.53, 2.58
234 processes: 177 sleeping, 57 running
Cpu states:
 LOAD   USER   NICE    SYS   IDLE  BLOCK  SWAIT   INTR   SSYS
 2.56   0.2%  98.4%   1.4%   0.0%   0.0%   0.0%   0.0%   0.0%
System Page Size: 4Kbytes
Memory: 1992392K (600392K) real, 4650248K (2476324K) virtual, 272100K free  Page
# 1/17
 TTY    PID USERNAME PRI NI   SIZE    RES STATE    TIME %WCPU  %CPU COMMAND
  ?   17366 oracle   245 22   870M  8568K run   2494:14 84.61 84.46 oracleDEVDB2
  ?   10502 oracle   185 22   855M  4352K run      0:12  5.27  5.26 oracleDEVDB2
  ?      63 root     128 20    72K    64K sleep 5979:36  2.16  2.16 fcachedaemon
  ?    3304 root     168 20 15792K   816K sleep 1262:46  0.53  0.53 utild
pts/3 10589 root     154 10 48720K  5180K sleep    0:00  0.49  0.48 glance
  ?    1805 root     154 20 18580K   372K sleep  873:34  0.38  0.38 cmclconfd
pts/1 10263 root     178 20 10752K  1508K run      0:03  0.29  0.29 top
  ?    6294 oracle   154 20  1272M  2468K sleep    0:10  0.20  0.20 ora_j000_DEV
  ?    1753 root     154 20 11160K   260K sleep  400:31  0.13  0.13 sendmail:
  ?   10594 root      50 10 30752K  4648K sleep    0:00  0.10  0.10 midaemon
  ?    2164 root     154 20  5744K   304K sleep  189:36  0.09  0.09 pwgrd
---------------------------------------------------------------------


VM Guest that runs well
Load averages: 0.05, 0.04, 0.04
199 processes: 166 sleeping, 32 running, 1 zombie
Cpu states:
CPU   LOAD   USER   NICE    SYS   IDLE  BLOCK  SWAIT   INTR   SSYS
 0    0.05   0.8%   0.0%   0.2%  99.0%   0.0%   0.0%   0.0%   0.0%
 1    0.04   1.2%   0.0%   0.0%  98.8%   0.0%   0.0%   0.0%   0.0%
---   ----  -----  -----  -----  -----  -----  -----  -----  -----
avg   0.05   1.0%   0.0%   0.0%  99.0%   0.0%   0.0%   0.0%   0.0%
Memory: 3328308K (3004544K) real, 5644416K (5217344K) virtual, 854000K free  Pag
e# 1/19
CPU TTY    PID USERNAME PRI NI   SIZE    RES STATE    TIME %WCPU  %CPU COMMAND
 1   ?   26019 oracle   154 20   766M  7056K sleep 5663:52  6.29  6.28 oracleTRD
 1   ?   16816 oracle   154 20   766M  7056K run   4504:51  3.94  3.93 oracleTRD
 0   ?   29531 oracle   152 20 63948K  5196K run    733:57  0.44  0.44 tnslsnr
 1   ?   15672 oracle   154 20   767M  9040K sleep   33:26  0.41  0.40 oracleTRD
 0   ?   27865 oracle   154 20   764M  5816K sleep    0:00  0.23  0.23 oracleTRD
 1   ?      54 root     152 20 20808K 18496K run   1033:21  0.22  0.22 vxfsd
 1   ?    2013 root     -16 20 32132K  8752K run    716:13  0.20  0.20 midaemon
 1 pts/1 27393 root     178 20 14636K   864K run      0:01  0.09  0.09 top
 1   ?    1851 root     152 20   766M 87632K run    475:24  0.06  0.06 java
 1   ?    2020 root     127 20 50156K 11932K sleep   64:54  0.05  0.05 scopeux
2

The first server appears to only have one CPU and the O/S is battling with Oracle.

3

Add to methyl's remark:
server 1, 1 CPU:

234 processes: 177 sleeping, 57 running

server 2, 2 CPUs:

199 processes: 166 sleeping, 32 running

In other words 15 more running processes to deal with having half the cpu power of the second...

That said, you did not say if the LVM configurations are identical, or the swap or the memory nor did you mention the SGA size of the oracle DB...

4

Hi Methyl,
Thanks for your quick reply. The Oracle instances are running with the smallest sga memory size, do you have any idea what HPUX processes or OS tuning could help the situtation?

5

Sorry, but no quick fix for this. The requirements for Oracle are clearly stated in their many detailed installation guides. Only a casual home user would ever run an Oracle database engine with one CPU.

6

Hi,

You hava a oracle session using 84.46% of the CPU, ask to dba verify session activity.

TTY PID USERNAME PRI NI SIZE RES STATE TIME %WCPU %CPU COMMAND
? 17366 oracle 245 22 870M 8568K run 2494:14 84.61 84.46 oracleDEVDB2