Return-Path:
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 13629 invoked from network); 29 Aug 2007 20:45:03 -0500
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
by 69.64.49.119 with SMTP; 29 Aug 2007 20:45:03 -0500
Received: from localhost (localhost [127.0.0.1])
by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CCD3E73495A;
Wed, 29 Aug 2007 21:06:25 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
with ESMTP id 31406-03-61; Wed, 29 Aug 2007 21:06:25 -0400 (EDT)
Received: from turing (localhost [127.0.0.1])
by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 22A217345C9;
Wed, 29 Aug 2007 21:06:25 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 29 Aug 2007 20:22:22 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9825273431D
for ; Wed, 29 Aug 2007 20:22:22 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
with ESMTP id 10933-03-18 for ;
Wed, 29 Aug 2007 20:22:22 -0400 (EDT)
Received: from mailrelay4.rabobank.com (mailrelay4.rabobank.com [203.62.217.146])
by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5938F73469C
for ; Wed, 29 Aug 2007 20:22:17 -0400 (EDT)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C7EAA1.35BEDA29"
Subject: Local write wait , wait event
Date: Thu, 30 Aug 2007 11:00:51 +1000
Message-ID: <49AD3377867B8A46A6B58C1551D4B55C016E5900@rabobank.com>
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
Thread-Topic: Local write wait , wait event
From: "VanZanen, J (Jacob)"
To:
X-OriginalArrivalTime: 30 Aug 2007 01:00:51.0467 (UTC) FILETIME=[35AF65B0:01C7EAA1]
X-archive-position: 1131
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: Jacob.VanZanen@rabobank.com
Precedence: normal
Reply-to: Jacob.VanZanen@rabobank.com
List-help:
List-unsubscribe:
List-software: Ecartis version 1.0.0
List-Id: oracle-l
X-List-ID: oracle-l
List-subscribe:
List-owner:
List-post:
List-archive:
X-list: oracle-l
X-Virus-Scanned: Debian amavisd-new at localhost.localdomain
------_=_NextPart_001_01C7EAA1.35BEDA29
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi All
I have found this archive post about this wait
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.=20
Regards Jonathan Lewis=20
I seem to be getting this wait event only during the creation of
indexes and according to session_wait it is on the temp files (file id).
Now I am creating these indexes noparallel but there is an alter session
enable parallel dml.
Could I be hitting the decribed scenario above on the sorting in the
temp tablespace. And if so how do I check it? Bit rusty on the tracing
as I have not done it for quite some time
Brgds
Jack
______________________________________________________________
This email, including any attachments, may be confidential or privileged,=
=20and is sent for the personal attention of the intended recipient. If =
you have received this email in error, please delete it immediately. The=
=20views expressed are not necessarily those of the Rabobank Group. The =
Group is not liable for the effects of any virus which may be contained i=
n this email.
If this email contains marketing material and you do not wish to receive =
such material by email in future, please reply to this email and place th=
e words "Remove My Details - Electronic Messages" in the Subject Header.
The Rabobank Group
Australia: 1800 025 484
New Zealand: 0800 500 933
______________________________________________________________
------_=_NextPart_001_01C7EAA1.35BEDA29
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Local write wait , wait event
Hi All
I have found this archive post&nbs=
p; about this wait
<Post>
The only time I have seen local write w=
ait and tracked it back to source, it has been the query co-ordinator cle=
aning up after parallel execution slaves have been involved in parallel c=
reate table / index. Each slave thinks it owns a segment, so creates a se=
gment header as the first block of the data it generates. The QC wipes al=
l 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=20
</Post>
I seem to be getting this wait event&nbs=
p; only during the creation of indexes and according to session_wait it i=
s on the temp files (file id).
Now I am creating these indexes noparall=
el but there is an alter session enable parallel dml.
Could I be hitting the decribed scenario=
=20above on the sorting in the temp tablespace. And if so how do I check =
it? Bit rusty on the tracing as I have not done it for quite some time
Brgds
Jack
This email, including any attachments, may be confidential=
=20or=20
privileged, and is sent for the personal attention of the intended=20
recipient. If you have received this email in error, please delete =
it=20
immediately. The views expressed are not necessarily those of the R=
abobank=20
Group. The Group is not liable for the effects of any virus which m=
ay be=20
contained in this email.
If this email contains marketing material and you do no=
t wish to=20
receive such material by email in future, please reply to this email and =
place=20
the words "Remove My Details - Electronic Messages" in the Subject=20
Header.
The Rabobank Group
Australia: 1800 025 484
New Zealand: 0800 500 933 =
FONT>
------_=_NextPart_001_01C7EAA1.35BEDA29--
--
http://www.freelists.org/webpage/oracle-l