Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: local write wait event

Re: local write wait event

From: Edgar Chupit <chupit_at_gmail.com>
Date: Mon, 11 Oct 2004 13:10:04 +0300
Message-ID: <a8f0771c04101103101cda2b0e@mail.gmail.com>


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 <matthewp_at_amazon.com> 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
Received on Mon Oct 11 2004 - 05:05:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US