From: SIMONE CRISTINA SPERANDIO (scristina@zogbi-promovel.com.br)
Date: Tue Jan 28 2003 - 09:02:34 EST
> All,
> My company is with a very great problem.
> We made the migration of Oracle 8 for oracle 9i.
> After the migration the server was very slow.
> All its area of swap is being consumed.
> Idle always in 0%
> I direct the reports of vmstat, mpstat, to sar.
> Help please.
>
> SUN E4500
> SAR
> zogbi24:> sar -u 10 10
>
> SunOS zogbi24 5.8 Generic_108528-15 sun4u 01/28/03
>
> 11:51:43 %usr %sys %wio %idle
> 11:51:53 54 46 0 0
> 11:52:03 53 47 0 0
> 11:52:14 48 52 0 0
> 11:52:24 50 50 0 0
> 11:52:34 49 51 0 0
> 11:52:44 50 50 0 0
> 11:52:54 48 52 0 0
> 11:53:04 48 52 0 0
> 11:53:14 49 51 0 0
> 11:53:24 53 47 0 0
> Average 50 50 0 0
> MPSTAT
> CPU minf mjf xcal intr ithr csw icsw migr smtx srw syscl
> usr sys wt idl
> 0 161 0 2091 1666 1391 954 208 100 757 0 6694 47 25 8
> 20
> 1 167 0 1169 320 100 1099 244 110 810 0 7328 49 23 9
> 19
> 4 171 0 1192 317 100 1082 241 108 806 0 7138 49 22 9
> 20
> 5 173 0 1220 321 100 1078 236 112 816 0 7214 50 22 9
> 19
> 8 165 0 1287 556 351 1042 227 108 773 0 7166 48 23 9
> 21
> 9 167 0 1196 549 345 1049 235 104 776 0 7239 50 23 8
> 19
> 12 168 0 1207 329 105 1095 233 115 806 0 7204 48 22 10
> 21
> 13 169 0 1177 370 145 1089 235 117 805 0 7359 50 22 9
> 19
> vmstat 5 5
> procs memory page disk faults cpu
> r b w swap free re mf pi po fr de sr s6 s1 s1 s1 in sy cs us
> sy id
> 14 4 0 7983496 3113368 161 1350 45 3 2 0 0 0 0 5 5 4340 57301 8501 49
> 23 29
> 68 24 0 4404176 200720 289 2997 38 6 3 0 0 0 0 4 4 7096 41599 12298 58
> 42 0
> 62 23 0 4417248 209456 220 2545 16 4 3 0 0 0 0 1 2 6727 45199 11874 56
> 44 0
> 58 24 0 4421296 215408 367 2701 1020 9 8 0 0 0 0 1 1 6744 42845 11640 57
> 43 0
> 72 24 0 4440616 230024 315 3240 27 11 9 0 0 0 0 3 3 6961 41234 11352 57
> 43 0
> iostat 5 5
> tty sd6 sd11 sd12 sd16 cpu
> tin tout kps tps serv kps tps serv kps tps serv kps tps serv us sy
> wt id
> 45 17934 0 0 0 0 0 6 54 5 8 53 5 4 49 23
> 9 20
> 177 75878 0 0 0 0 0 0 14 1 19 14 1 5 56 44
> 0 0
> 174 64912 0 0 0 0 0 0 36 2 15 36 2 8 55 45
> 0 0
> 151 73447 0 0 0 0 0 0 58 2 18 54 1 9 58 42
> 0 0
> 178 71771 0 0 0 0 0 0 29 1 19 27 1 5 57 43
> 0 0
>
>
>
> [ ]4s
> Simone Cristina Sperandio
> Adm. Unix
> Zogbi-Promovel - Brasil
> 3038-3385
> 3031-0267
> scristina@zogbi-promovel.com.br
> http://www.zogbi.com.br
_______________________________________________
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:25:43 EDT