I have to ask.
Is the server Solaris?
If so, iowait may not mean what you think it means. I'll await your answer.
Paul
> >
> > On 6/22/05, David Turner <dnt9000_at_yahoo.com> wrote:
> > > Periodically we have a problem with our raid arrays
> > > and suddenly iowait shoots up. Does anyone have a
> > > method of identifying the source of iowait. I find it
> > > hard to tell whether say the cache on a raid array was
> > > disabled versus more processes performing table scans.
> > > I understand historical tracking but often don't have
> > > this info on the databases. Currently working with 9i.
> > >
> > > Thx, Dave
> > >
> > >
> > >
> > > ____________________________________________________
> > > Yahoo! Sports
> > > Rekindle the Rivalries. Sign up for Fantasy Football
> > > http://football.fantasysports.yahoo.com
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> > >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
>
> Greetings Dave,
>
> I am assuming that its a UNIX server,
>
> start collecting vmstat , sar and iostat with 1 sec timing
> and comapre the results to STATSPACK reports during performance issue
> , apart from other SEGMENT stats v$views ...
>
>
>
> --
> Regards & Thanks
> BN
> --
> http://www.freelists.org/webpage/oracle-l
>
--
--
Paul Vallee
President, The Pythian Group, Inc.
http://www.pythian.com
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 27 2005 - 12:28:02 CDT
