RE: local write wait event

From: Parker, Matthew <matthewp_at_amazon.com>
Date: Mon, 11 Oct 2004 01:42:46 -0700
Message-ID: <F385925F530F6C4081F1659F71640EB3AD0F80@ex-mail-sea-04.ant.amazon.com>

"local write wait" refers to the wait in a session to reuse the same = buffer, while dbwr is trying to flush the same dirty buffer. There are variety of bugs listed in Metalink refering to this on the 10G = version related to truncates. Could be one of the bugs or an OS problem = with the disk dbwr is trying to write to.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Edgar Chupit Sent: Sunday, October 10, 2004 11:58 PM
To: oracle-l_at_freelists.org
Subject: local write wait event

Dear List,

Tracing one of the user sessions I get a lot of waits on "local write = wait". We are using 10.0.3, I've searched metalink and in the book about = OWI events, but couldn't find any information about this event, while = searching in the archives I've found post by K Gopalakrishnan, that this = event should never be seen in normal databases. Maybe there is a more = detailed description of this wait event?

--

Edgar
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 11 2004 - 03:38:22 CDT