[SunHELP] iowait problem...
Naser Ali
sunhelp at sunhelp.org
Thu May 3 06:27:18 CDT 2001
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C0D3C4.02E88EE0
Content-Type: text/plain;
charset="iso-8859-1"
Hello,
There can be 100s of different reasons behind this IO wait. One has to know
more about the DB layout, structures, Ora tunable, OS tunables, what kind of
work is being done on the DB at the time and so on and so forth. The list is
long. It involves every hardware and software component.My best advice to
you is to get DB Tuner from Precise software. call your EMC rep and they
will direct you in right direction. Trust me it is a great tool. Any
solution provided to this problem by some one who do not know your env can
be detrimental to your system.
For starters though, you need more memory, or tune and re-tune your init.ora
untill you get some perf gain.
Aali Naser
-----Original Message-----
From: Devrim Yilmaz (Garanti Teknoloji) [mailto:DevrimY at garanti.com.tr]
Sent: Thursday, May 03, 2001 6:15 AM
To: 'sunhelp at sunhelp.org'
Subject: [SunHELP] iowait problem...
Hi;
Here is my case. This server has lots of iowaits and i want to find the
reason. If you have any ideas, it makes me happy.
Regards..
dEVRim-
last pid: 1677; load averages: 2.13, 2.16, 2.17 13:01
77 processes: 76 sleeping, 1 on cpu
CPU states: 0.0% idle, 2.6% user, 4.8% kernel, 92.6% iowait, 0.0% swap
Memory: 512M real, 7632K free, 1076M swap in use, 319M swap free
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
578 oracle9 1 60 0 267M 179M sleep 241:53 1.03% oracle
572 oracle9 1 60 0 262M 179M sleep 240:11 0.83% oracle
574 oracle9 1 60 0 268M 179M sleep 247:19 0.72% oracle
622 oracle9 5 59 0 111M 2032K sleep 156:58 0.57% webcached
596 oracle9 8 60 0 11M 5216K sleep 67:47 0.34% jre
614 oracle9 8 59 0 73M 1440K sleep 140:34 0.32% webcached
4250 oracle9 39 30 0 70M 12M sleep 18:54 0.28% java
1656 root 1 58 0 2552K 624K cpu 0:01 0.20% top
1676 oracle9 5 58 0 13M 4896K sleep 0:00 0.14% httpd
1677 oracle9 5 58 0 13M 4656K sleep 0:00 0.09% httpd
644 oracle9 4 58 0 14M 7120K sleep 5:10 0.07% httpd
1675 oracle9 5 58 0 13M 4656K sleep 0:00 0.07% httpd
576 oracle9 1 58 0 263M 138M sleep 255:29 0.07% oracle
1665 oracle9 4 58 0 14M 7272K sleep 0:00 0.06% httpd
17701 oracle9 4 58 0 14M 7016K sleep 0:39 0.05% httpd
_______________________________________________
SunHELP maillist - SunHELP at sunhelp.org
http://www.sunhelp.org/mailman/listinfo/sunhelp
------_=_NextPart_001_01C0D3C4.02E88EE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>RE: [SunHELP] iowait problem...</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Hello,</FONT>
<BR><FONT SIZE=3D2>There can be 100s of different reasons behind this =
IO wait. One has to know more about the DB layout, structures, Ora =
tunable, OS tunables, what kind of work is being done on the DB at the =
time and so on and so forth. The list is long. It involves every =
hardware and software component.My best advice to you is to get DB =
Tuner from Precise software. call your EMC rep and they will direct you =
in right direction. Trust me it is a great tool. Any solution provided =
to this problem by some one who do not know your env can be detrimental =
to your system.</FONT></P>
<P><FONT SIZE=3D2>For starters though, you need more memory, or tune =
and re-tune your init.ora untill you get some perf gain.</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Aali Naser</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Devrim Yilmaz (Garanti Teknoloji) [<A =
HREF=3D"mailto:DevrimY at garanti.com.tr">mailto:DevrimY at garanti.com.tr</A>=
]</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, May 03, 2001 6:15 AM</FONT>
<BR><FONT SIZE=3D2>To: 'sunhelp at sunhelp.org'</FONT>
<BR><FONT SIZE=3D2>Subject: [SunHELP] iowait problem...</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Hi;</FONT>
<BR><FONT SIZE=3D2>Here is my case. This server has lots of iowaits and =
i want to find the</FONT>
<BR><FONT SIZE=3D2>reason. If you have any ideas, it makes me =
happy.</FONT>
</P>
<P><FONT SIZE=3D2>Regards..</FONT>
<BR><FONT SIZE=3D2>dEVRim-</FONT>
</P>
<P><FONT SIZE=3D2>last pid: 1677; load averages: =
2.13, 2.16, =
2.17 &n=
bsp; 13:01</FONT>
<BR><FONT SIZE=3D2>77 processes: 76 sleeping, 1 on =
cpu &nb=
sp; &nb=
sp; &nb=
sp; </FONT>
<BR><FONT SIZE=3D2>CPU states: 0.0% idle, 2.6% user, =
4.8% kernel, 92.6% iowait, 0.0% swap </FONT>
<BR><FONT SIZE=3D2>Memory: 512M real, 7632K free, 1076M swap in use, =
319M swap =
free =
</FONT>
<BR><FONT =
SIZE=3D2> &nb=
sp; &nb=
sp; &nb=
sp; &nb=
sp; &nb=
sp; &nb=
sp; </FONT>
<BR><FONT SIZE=3D2> PID USERNAME THR PRI NICE =
SIZE RES STATE TIME CPU =
COMMAND </FONT>
<BR><FONT SIZE=3D2> 578 oracle9 1 =
60 0 267M 179M sleep 241:53 =
1.03% oracle </FONT>
<BR><FONT SIZE=3D2> 572 oracle9 1 =
60 0 262M 179M sleep 240:11 =
0.83% oracle </FONT>
<BR><FONT SIZE=3D2> 574 oracle9 1 =
60 0 268M 179M sleep 247:19 =
0.72% oracle </FONT>
<BR><FONT SIZE=3D2> 622 oracle9 5 =
59 0 111M 2032K sleep 156:58 0.57% =
webcached </FONT>
<BR><FONT SIZE=3D2> 596 oracle9 8 =
60 0 11M 5216K sleep =
67:47 0.34% =
jre </FONT>
<BR><FONT SIZE=3D2> 614 oracle9 8 =
59 0 73M 1440K sleep 140:34 =
0.32% webcached </FONT>
<BR><FONT SIZE=3D2> 4250 oracle9 39 =
30 0 70M 12M =
sleep 18:54 0.28% =
java </FONT>
<BR><FONT SIZE=3D2> 1656 root =
1 58 0 2552K 624K =
cpu 0:01 0.20% =
top </FONT>
<BR><FONT SIZE=3D2> 1676 oracle9 5 =
58 0 13M 4896K sleep =
0:00 0.14% httpd =
</FONT>
<BR><FONT SIZE=3D2> 1677 oracle9 5 =
58 0 13M 4656K sleep =
0:00 0.09% httpd =
</FONT>
<BR><FONT SIZE=3D2> 644 oracle9 4 =
58 0 14M 7120K sleep =
5:10 0.07% httpd =
</FONT>
<BR><FONT SIZE=3D2> 1675 oracle9 5 =
58 0 13M 4656K sleep =
0:00 0.07% httpd =
</FONT>
<BR><FONT SIZE=3D2> 576 oracle9 1 =
58 0 263M 138M sleep 255:29 =
0.07% oracle </FONT>
<BR><FONT SIZE=3D2> 1665 oracle9 4 =
58 0 14M 7272K sleep =
0:00 0.06% httpd =
</FONT>
<BR><FONT SIZE=3D2> 17701 oracle9 4 =
58 0 14M 7016K sleep =
0:39 0.05% httpd =
</FONT>
<BR><FONT =
SIZE=3D2> &nb=
sp; &nb=
sp; &nb=
sp; &nb=
sp; &nb=
sp; &nb=
sp; </FONT>
</P>
<P><FONT =
SIZE=3D2>_______________________________________________</FONT>
<BR><FONT SIZE=3D2>SunHELP maillist - =
SunHELP at sunhelp.org</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://www.sunhelp.org/mailman/listinfo/sunhelp" =
TARGET=3D"_blank">http://www.sunhelp.org/mailman/listinfo/sunhelp</A></F=
ONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C0D3C4.02E88EE0--
More information about the SunHELP
mailing list