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