From oracle-l-bounce@freelists.org Mon Aug 8 04:11:33 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j789BW6s014235 for ; Mon, 8 Aug 2005 04:11:32 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j789BTIP014222 for ; Mon, 8 Aug 2005 04:11:29 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EF59F1DCC10; Mon, 8 Aug 2005 04:11:26 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30218-01; Mon, 8 Aug 2005 04:11:26 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 40B8E1DC79D; Mon, 8 Aug 2005 04:11:26 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C59BF8.E1CA1D80" Subject: RE: Buffer Sort explanation Date: Mon, 8 Aug 2005 11:09:30 +0200 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Buffer Sort explanation Thread-Index: AcWbxPQjPsRCCzhARyqcg+JlBpCtmQAMytcQ From: "Christian Antognini" To: Cc: X-archive-position: 23525 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Christian.Antognini@trivadis.com Precedence: normal Reply-To: Christian.Antognini@trivadis.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.5 required=5.0 tests=AWL,BAYES_00,HTML_50_60, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C59BF8.E1CA1D80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi =20 > Rows Operation > =3D=3D=3D=3D=3D=3D=3D=3D=3D = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >a) 105 BITMAP MERGE >b) 351549 BITMAP KEY ITERATION >c) 127009880 BUFFER SORT >d) 1607720 TABLE ACCESS FULL SYS_TEMP_4254956840 >e) 351549 BITMAP INDEX RANGE SCAN OBJ#(3441108) =20 I'm not able to explain you what the BUFFER SORT exactly does in this = case (it should only get the data from the temporary table and prepare = them for the "join" with the index on the fact table... Anyway, each = time I have a problem with a star transformation with temporary tables I = try to disable the temporary tables (they were/are buggy!). Therefore = try star_transformation_enabled=3Dtemp_disable. =20 =20 Regards, Chris =20 ------_=_NextPart_001_01C59BF8.E1CA1D80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi

 

>=A0 Rows=A0=A0=A0=A0=A0=A0 Operation
>=A0 =3D=3D=3D=3D=3D=3D=3D=3D=3D=A0 = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>a)=A0=A0=A0=A0=A0=A0 105 BITMAP MERGE
>b)=A0=A0=A0 351549=A0=A0=A0 BITMAP KEY ITERATION
>c) 127009880=A0=A0=A0=A0 BUFFER SORT
>d)=A0=A0 1607720 =A0=A0=A0=A0=A0TABLE ACCESS FULL = SYS_TEMP_4254956840
>e)=A0=A0=A0 351549=A0=A0 BITMAP INDEX RANGE SCAN = OBJ#(3441108)

 

I’m not able to explain you = what the BUFFER SORT exactly does in this case (it should only get the data from = the temporary table and prepare them for the “join” with the = index on the fact table… Anyway, each time I have a problem with a star transformation with temporary tables I try to disable the temporary = tables (they were/are buggy!). Therefore try = star_transformation_enabled=3Dtemp_disable.

 

 

Regards,

Chris

 

------_=_NextPart_001_01C59BF8.E1CA1D80-- -- http://www.freelists.org/webpage/oracle-l