From: paulose kutty (paulosekutty@hotmail.com)
Date: Fri Sep 27 2002 - 01:42:38 EDT
Hi all,
Our database server, (SUN 4800 ,OS- Solaris 8, 4 CPU, 4 GB RAM and 80 GB
database in Sun Storedge T300 ) running oracle database server is showing
high %sys in sar reports while executing long running queries. We have 400
concurrent oracle users connected to the database. The sar report is shown
below.
Out put of sar
15:06:53 %usr %sys %wio %idle
15:06:54 38 53 6 3
15:06:55 49 38 1 12
15:06:56 39 26 1 35
15:06:58 34 27 3 36
15:06:59 37 26 3 33
15:07:00 33 19 4 44
15:07:01 60 37 3 0
15:07:02 50 49 1 1
15:07:03 52 48 0 0
15:07:04 47 45 6 3
Output of vmstat
procs memory page disk faults cpu
r b w swap free re mf pi po fr de sr s0 s1 s6 sd in sy cs us sy
id
0 0 0 13249528 2637176 229 382 525 3 3 0 0 2 2 0 0 1974 2278 2572 6 3
91
4 1 0 12939424 2284760 2971 1290 6040 0 0 0 0 0 0 0 0 4864 20794 4968 77 22
0
2 1 0 12939904 2285176 4386 718 5648 0 0 0 0 0 0 0 0 4154 23079 4490 78 21
0
7 0 0 12940880 2286088 3141 1193 4728 0 0 0 0 0 0 0 0 3790 20403 3485 82 18
0
5 0 0 12940800 2286008 3090 30 5280 0 0 0 0 0 0 0 0 3266 19386 2942 77 23
0
1 0 0 12940696 2285904 4082 12 4480 0 0 0 0 0 0 0 0 4106 22197 3908 79 21
0
3 3 0 12940688 2285808 4116 1253 4560 0 0 0 0 0 0 0 0 4133 21512 4028 76 23
2
5 0 0 12940896 2285744 4752 1811 5968 0 0 0 0 0 0 0 0 4651 22045 5180 76 22
2
4 0 0 12941120 2286264 4530 760 4056 0 0 0 0 0 0 0 0 4285 18866 4159 77 21
1
4 1 0 12941000 2286144 5883 25 6264 0 0 0 0 0 0 0 0 2742 18868 1913 80 17
2
What could be the reason . Is it because of any contention? If so how to
find out the files / processes / system calls causing contention?
Thanks in advance
Paulosekutty
Manager (IT)
South Indian Bank Ltd.
_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:24:59 EDT