Re: What is a local write wait?

This event is one of those 'you would never see' in normal database operations. As I have mentioned
in my earlier post, existance of this event translates in to some serious I/O issues or broken disk in RAID05
or something similar to that..

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, November 03, 2003 10:24 PM

>
> Thanks KG.
>
> There were underlying OS I/O issues. The SA is looking to fix the same.
>
> Regards
> Raj
> __________________________________
> Rajesh L. Rao
> DCI - Triad, Oracle DBA
> IBM Global Services, JPMC Account
> Phone: 516 5746065
> E-mail: raor_at_us.ibm.com
>
>
>
>
>
> "K
> Gopalakrishnan To: Multiple recipients of
list ORACLE-L <ORACLE-L_at_fatcity.com>
> " cc:
> <kaygopal_at_yaho Subject: Re: What is a local
write wait?
> o.com>
> Sent by:
> ml-errors_at_fatc
> ity.com
>
>

> 11/01/2003
> 09:54 AM
> Please respond
> to ORACLE-L
>
>
>
>
>
>
> Rajesh:
>
> Typically DBWR has to free up some buffers when you want to read something
> from the disk. During this process there are chances
> that you will be waiting for your local buffer (i.e blocks
> dirtied/invalidated by your session) to be written to disk. During this
> time
> the
> waits are shown as local write waits.
>
> BTW do you have any other write waits or just seeing local waits? And
also
> are you noticing any timeouts for this waits? Typically
> we wait for local wait up to one second and spin (or retry) again..
> Timeouts
> for local write indicates a serious problem unless you
> have tiny buffer cache or extremely slow disk'
>
>
> KG
>
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Saturday, November 01, 2003 12:54 PM
>
>
> > Was creating an index with a degree of 4, and in unrecoverable manner?
> > There were few waits for an event called "local write wait". Can anyone
> > shed more light on this wait?
> >
> > Thanks
> > Raj
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: Rajesh.Rao_at_jpmchase.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: kaygopal_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).