Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 8270 invoked from network); 26 Oct 2007 06:49:16 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 26 Oct 2007 06:49:15 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9A3AB7A696C; Fri, 26 Oct 2007 07:49:15 -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 28081-03; Fri, 26 Oct 2007 07:49:15 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1C3347A65A3; Fri, 26 Oct 2007 07:49:15 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 26 Oct 2007 07:03:17 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ED33B7A58BC for ; Fri, 26 Oct 2007 07:03:16 -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 21523-01 for ; Fri, 26 Oct 2007 07:03:16 -0400 (EDT) Received: from outbound.icp-qv1-irony-out2.iinet.net.au (outbound.icp-qv1-irony-out2.iinet.net.au [203.59.1.107]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4E24A7A4A10 for ; Fri, 26 Oct 2007 07:03:15 -0400 (EDT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AgAAANhmIUd8qlvy/2dsb2JhbAAM X-IronPort-AV: E=Sophos;i="4.21,332,1188748800"; d="scan'208";a="222820371" Received: from unknown (HELO [10.1.1.6]) ([124.170.91.242]) by outbound.icp-qv1-irony-out2.iinet.net.au with ESMTP; 26 Oct 2007 19:03:13 +0800 Message-ID: <4721C972.60900@iinet.net.au> Date: Fri, 26 Oct 2007 21:03:14 +1000 From: Nuno Souto User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502) X-Accept-Language: en-us, en MIME-Version: 1.0 CC: oracle-l@freelists.org Subject: Re: WRONG RESULTS bug in 9.2.x, 10.1.x and 10.2.x References: <04DDF147ED3A0D42B48A48A18D574C4508B6EAED@NT15.oneneck.corp> In-Reply-To: <04DDF147ED3A0D42B48A48A18D574C4508B6EAED@NT15.oneneck.corp> Content-Type: text/plain; charset=us-ascii; format=flowed X-archive-position: 2648 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: dbvision@iinet.net.au Precedence: normal Reply-to: dbvision@iinet.net.au 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 Allen, Brandon wrote,on my timestamp of 26/10/2007 3:24 AM: > There are patches available and a workaround of setting the hidden > parameter _table_lookup_prefetch_size=0. > > Check out Metalink# 406966.1 for more info. OMG! Another one... Great: just when I was starting to get some faith in 10.2.0.3... -- Cheers Nuno Souto in sunny Sydney, Australia dbvision@iinet.net.au -- http://www.freelists.org/webpage/oracle-l