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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > > > > > "K > Gopalakrishnan To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > " cc: > <[EMAIL PROTECTED] Subject: Re: What is a local write wait? > o.com> > Sent by: > [EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
