Hai all,

My OS is RHEL ES 4.0. we are runnning Oracle EBS on the same.. we have initially only few users connected to that..As am monitoring the OS, I came across this output :

*******************************************************************
Linux 2.6.9-42.ELsmp (alioracle.ali.com.kw) 10/30/2007

10:07:46 AM CPU %user %nice %system %iowait %idle
10:07:47 AM all 100.00 0.00 0.00 0.00 0.00
10:07:48 AM all 54.55 0.00 45.45 0.00 0.00
10:07:49 AM all 0.00 0.00 50.00 50.00 0.00
10:07:50 AM all 100.00 0.00 0.00 0.00 0.00
10:07:51 AM all 50.00 0.00 50.00 0.00 0.00
Average: all 52.94 0.00 41.18 5.88 0.00
******************************************************************
we have only 4 users connected to the machine.. so, the output of top command as follows :

[applprod@alioracle ~]$ top
top - 10:08:45 up 63 days, 12:44, 5 users, load average: 0.12, 0.12, 0.09
Tasks: 480 total, 1 running, 479 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.2% us, 0.1% sy, 0.0% ni, 99.7% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 4148304k total, 4097560k used, 50744k free, 51020k buffers
Swap: 8217236k total, 7764k used, 8209472k free, 2913484k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
27253 applprod 16 0 2436 1212 756 R 1 0.0 0:00.13 top
23570 applprod 16 0 25668 5620 816 S 1 0.1 0:01.31 jre
23868 applprod 16 0 7228 3468 2156 S 0 0.1 0:01.74 FNDCRM
1 root 16 0 2048 588 504 S 0 0.0 0:27.43 init
2 root RT 0 0 0 0 S 0 0.0 0:06.67 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:00.12 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:02.51 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.10 ksoftirqd/1
6 root RT 0 0 0 0 S 0 0.0 0:01.54 migration/2
7 root 34 19 0 0 0 S 0 0.0 0:00.21 ksoftirqd/2
8 root RT 0 0 0 0 S 0 0.0 0:01.02 migration/3
9 root 34 19 0 0 0 S 0 0.0 0:00.17 ksoftirqd/3
10 root RT 0 0 0 0 S 0 0.0 0:00.55 migration/4
11 root 34 19 0 0 0 S 0 0.0 0:00.17 ksoftirqd/4
12 root RT 0 0 0 0 S 0 0.0 0:00.41 migration/5
13 root 34 19 0 0 0 S 0 0.0 0:00.22 ksoftirqd/5
14 root RT 0 0 0 0 S 0 0.0 0:00.31 migration/6
15 root 34 19 0 0 0 S 0 0.0 0:00.17 ksoftirqd/6
16 root RT 0 0 0 0 S 0 0.0 0:00.62 migration/7
17 root 34 19 0 0 0 S 0 0.0 0:00.13 ksoftirqd/7
18 root 5 -10 0 0 0 S 0 0.0 0:00.00 events/0
19 root 5 -10 0 0 0 S 0 0.0 0:00.00 events/1
20 root 5 -10 0 0 0 S 0 0.0 0:00.00 events/2
21 root 5 -10 0 0 0 S 0 0.0 0:00.00 events/3
22 root 5 -10 0 0 0 S 0 0.0 0:00.00 events/4
23 root 5 -10 0 0 0 S 0 0.0 0:00.00 events/5
24 root 5 -10 0 0 0 S 0 0.0 0:00.00 events/6
25 root 5 -10 0 0 0 S 0 0.0 0:00.00 events/7
26 root 5 -10 0 0 0 S 0 0.0 0:00.00 khelper
27 root 13 -10 0 0 0 S 0 0.0 0:00.00 kacpid
118 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/0
119 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/1
120 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/2
121 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/3
122 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/4
123 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/5
124 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/6
******************************************************************

is this behaviour normal ?.... I want to know which user process all the resource ?..
output as follows :

[applprod@alioracle ~]$ sar -b 5 10
Linux 2.6.9-42.ELsmp (alioracle.ali.com.kw) 10/30/2007

10:09:41 AM tps rtps wtps bread/s bwrtn/s
10:09:46 AM 0.00 0.00 0.00 0.00 0.00
10:09:51 AM 0.00 0.00 0.00 0.00 0.00
10:09:56 AM 0.00 0.00 0.00 0.00 0.00
10:10:01 AM 0.00 0.00 0.00 0.00 0.00
10:10:06 AM 0.00 0.00 0.00 0.00 0.00

10:10:06 AM tps rtps wtps bread/s bwrtn/s
10:10:11 AM 0.00 0.00 0.00 0.00 0.00
10:10:16 AM 0.00 0.00 0.00 0.00 0.00
10:10:21 AM 0.00 0.00 0.00 0.00 0.00
10:10:26 AM 0.00 0.00 0.00 0.00 0.00
10:10:31 AM 0.00 0.00 0.00 0.00 0.00
Average: 0.00 0.00 0.00 0.00 0.00
***************************************************************
can any1 guide ?


Thanks
Yusuf

Was Oracle running any heavy processing at the time of the sar?

Did this settle down at any point?

Is this a new installation or have there been any changes recently?

What spec machine are you running this on?

I can't see any database processes in the output so I'm assuming the back end database is on a seperate box (this is a good thing)

If you have Oracle support, it might be best to contact them.

Thanks buddy for your answer.. but, no even If I shutdown the oracle processes also, it still remain the same.

any ideas ?


Yusuf

Are you getting slow responses?

The top command is showing 99.7% idle.

Is this a new installation?

Have there been any changes recently?

top command is ok..

but the report sar 1 5 sounds fishy...

no changes made to the environment.

thanks
yusuf

Interesting...

The top and sar outputs where run at the same point in time?

What do you get with:
I'm assuming responses are fine and thats what is causing you to doubt the output from sar.

Thanks friend for ur answer..
***********************************************

Linux 2.6.9-42.ELsmp (alioracle.ali.com.kw) 11/03/2007

09:00:29 AM CPU %user %nice %system %iowait %idle
09:00:32 AM all 78.57 0.00 21.43 0.00 0.00
09:00:35 AM all 60.00 0.00 20.00 20.00 0.00
09:00:38 AM all 66.67 0.00 33.33 0.00 0.00
09:00:41 AM all 46.15 0.00 53.85 0.00 0.00
09:00:44 AM all 50.00 0.00 8.82 41.18 0.00
Average: all 60.24 0.00 21.69 18.07 0.00
[oraprod@alioracle bdump]$ which sar
/usr/bin/sar
[oraprod@alioracle bdump]$ rpm -q sysstat
sysstat-5.0.5-11.rhel4
********************************************************************

Thanks in advance
Yusuf

You might want to start by upgrading your sysstat package.

On Centos 4.5 the sysstat RPM I have is sysstat-5.0.5015.0.1.el4

Centos is a redhat clone and as such I would expect the package numbers to be pretty much the same (appart from the renaming to remove the 'rh' from rhel4)