From oracle-l-bounce@freelists.org Mon Oct 11 05:05:32 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i9BA5WC25649 for ; Mon, 11 Oct 2004 05:05:32 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i9BA5WI25644 for ; Mon, 11 Oct 2004 05:05:32 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E6C6172C549; Mon, 11 Oct 2004 05:11:38 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00977-39; Mon, 11 Oct 2004 05:11:38 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 56D9E72C530; Mon, 11 Oct 2004 05:11:38 -0500 (EST) Message-ID: Date: Mon, 11 Oct 2004 13:10:04 +0300 From: Edgar Chupit To: "Parker, Matthew" Subject: Re: local write wait event Cc: oracle-l@freelists.org In-Reply-To: Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: X-archive-position: 10890 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: chupit@gmail.com Precedence: normal Reply-To: chupit@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Dear Matthew, In my case I see this event after 'direct path write temp' wait event, It could be a disk problem, because some time ago I already had problems with disk where the temp tablespace is located, I'll dig deeper into it. On Mon, 11 Oct 2004 01:42:46 -0700, Parker, Matthew wrote: > "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. -- Edgar -- http://www.freelists.org/webpage/oracle-l