From: SIMONE CRISTINA SPERANDIO (scristina@zogbi-promovel.com.br)
Date: Tue Jan 28 2003 - 08:58:57 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
* 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