Summary: V880 slow with scan rates in thousands

Thanks to Richard Skelton for the instantaneous response :
  Top in Solaris can sort by size:-
  Press o type size
  also better to use prstat -s size

& the SIZE column in prstat/top showed that among the largest
values of SIZE are owned by oracle processes.

Initially stopping all applications did not help bring down the
scan rate;  after stopping all the 6 Oracle instances, the scan
rate came to 0.

We're not able to reproduce this problem after all the 6 Oracle
instances & the application are started up again.


Thanks to Maciej for responding within 15 minutes.  We'll need
to do a post-mortem to see which process chews up the memory
- difficult to justify to add RAM unless the problem is persistent
& we can pinpoint the culprit.


Thanks
U





On 8/4/08, sunhux G <sunhux@gmail.com> wrote:
>
> Hi,
>
>
>
> Just today, the scan rates of our V880 jumped to thousands
> (used to be 0).  CPU utilization is 63-87% idle :
>
> vmstat 2:
>  0 1 0 18565856 59753 395 172 582 30 54 40184 171 20 0 0 0 1231 1202 892 4
> 7 89
>  0 6 0 14795056 12778  93 215 1003 311 1582 32552 2811 24 0 0 0 748 556
> 1148 2 5 93
>  0 3 0 14795056 12777  86 205 970 448 1608 26376 1975 7 0 0 0 791 936 1154
> 3 5 91
>  0 3 0 14793024 12694 152 546 3073 975 3300 113240 4846 17 0 0 0 920 1223
> 1228 5 12 83
>  0 3 0 14795648 13065 114 265 1166 100 100 91728 0 21 0 0 0 651 634 1193 2
> 3 95
>  0 3 0 14795648 12783  58 178 907 585 1091 74304 2316 7 0 0 0 709 600 1055
> 2 5 93
>  7 3 0 14794864 12804 148 350 2838 957 2199 115176 30854 18 0 0 0 751 658
> 1177 3 18 79
>
>  0 4 0 15158376 128016 153 302 1009 1555 1627 44648 16005 4 0 0 0 591 575
> 1075 3 10 87
>  0 3 0 15158376 128584 328 479 990 3485 3616 36168 30039 20 0 0 0 660 468
> 1127 2 13 85
>  0 3 0 15158376 128344 384 494 784 3813 3916 29304 26749 14 0 0 0 615 517
> 1030 3 13 84
>  0 3 0 15158376 127144 350 491 884 3590 3821 23744 22907 7 0 0 0 600 479
> 1027 2 12 86
>
> iostat 2:
>
>    tty        md3          md104         md105         md106           cpu
>  tin tout kps tps serv  kps tps serv  kps tps serv  kps tps serv   us sy wt
> id
>    0    1 480  20    8    0   0    7    0   0   13    2   0   17    4  7  0
> 89
>    0  117  85   7    9    0   0    0    0   0    0    0   0    0    5  3  0
> 92
>    0   40 121  15   10    0   0    0    0   0    0    0   0    0    2  3  0
> 95
>
> top output:
>
> last pid: 26802;  load averages:  0.28,  0.38,
> 0.54                                    17:01:49
> 165 processes: 163 sleeping, 1 zombie, 1 on cpu
> CPU states:     % idle,     % user,     % kernel,     % iowait,     % swap
> Memory: 8192M real, 5703M swap in use, 17G swap free
>
>   PID USERNAME THR PRI NICE  SIZE   RES STATE   TIME    CPU COMMAND
> 26802 root       1   0    0 2392K 1864K cpu0    0:00  1.23% top
> 18999 root       1  59    0 1240K  456K sleep  10:18  0.28% dd
> 19635 root       1  59    0 1240K  456K sleep  10:11  0.28% dd
> 26800 oracle10   1  59    0  524M  507M sleep   0:00  0.23% oracle
>  7574 oracle10   1  59    0  579M  556M sleep   0:37  0.11% oracle
>  7860 oracle10   1  59    0 1329M 1304M sleep   0:42  0.11% oracle
>  7570 oracle10   1  59    0  580M  556M sleep   0:42  0.10% oracle
>  7720 oracle10   1  59    0  524M  500M sleep   0:42  0.10% oracle
>  7504 oracle10   1  59    0 1031M 1008M sleep   0:07  0.10% oracle
>  7776 oracle10   1  59    0 1329M 1304M sleep   0:43  0.09% oracle
>
>
>
> I know in Linux, the top command can sort by CPU/memory/swap
>
> usage (just by pressing F  & select the sort column/key) but the
>
> top utility do not have this in Solaris
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers