Re: local write wait event
- From: Edgar Chupit <chupit@xxxxxxxxx>
- To: Jonathan Lewis <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 13 Oct 2004 08:53:05 +0300
Dear Jonathan,
I would like to thank all thread participants for help in solving this issue.
As I mentioned in one of my posts, we already had some troubles with
this disk some time ago, but that time we thought that it was due to
overheating. After checking the OS logs with the sysadmin We've
decided to replace this disk and as temporary solution, don't use this
disk anymore. I've recreated temporary tablespace on another disk, and
after that I haven't seen this event.
On Tue, 12 Oct 2004 21:05:40 +0100, Jonathan Lewis
<jonathan@xxxxxxxxxxxxxxxxxx> wrote:
>
> The only time I have seen local write wait
> and tracked it back to source, it has been
> the query co-ordinator cleaning up after
> parallel execution slaves have been involved
> in parallel create table / index. Each slave
> thinks it owns a segment, so creates a segment
> header as the first block of the data it generates.
> The QC wipes all but one of them and puts them
> into the segment free list.
>
> There may be other reasons that I've not yet
> come across.
>
> Regards
>
> Jonathan Lewis
>
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> The Co-operative Oracle Users' FAQ
>
> http://www.jlcomp.demon.co.uk/seminar.html
> Optimising Oracle Seminar - schedule updated Sept 19th
>
--
Edgar
--
//www.freelists.org/webpage/oracle-l
Other related posts:
