Re: local write wait event

  • From: Edgar Chupit <chupit@xxxxxxxxx>
  • To: "Parker, Matthew" <matthewp@xxxxxxxxxx>
  • Date: Mon, 11 Oct 2004 13:10:04 +0300

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@xxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l

Other related posts: