Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 11847 invoked from network); 7 Dec 2007 11:40:59 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 7 Dec 2007 11:40:58 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 14C657D5F20; Fri, 7 Dec 2007 12:40:55 -0500 (EST) 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 31080-02; Fri, 7 Dec 2007 12:40:55 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 869EA7D5B2B; Fri, 7 Dec 2007 12:40:54 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 07 Dec 2007 12:38:45 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5AFD97D5A1C for ; Fri, 7 Dec 2007 12:38:45 -0500 (EST) 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 30355-04 for ; Fri, 7 Dec 2007 12:38:45 -0500 (EST) Received: from NT15.oneneck.corp (dot092host.oneneck.net [63.226.42.92]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1353C7D5A55 for ; Fri, 7 Dec 2007 12:38:44 -0500 (EST) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: Wrong Results - Bad Execution Plan Date: Fri, 7 Dec 2007 10:38:39 -0700 Message-ID: <04DDF147ED3A0D42B48A48A18D574C450995AF30@NT15.oneneck.corp> In-Reply-To: <004b01c838ea$4d090a80$6701a8c0@itasoftware.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Priority: normal Thread-Topic: Wrong Results - Bad Execution Plan References: <004b01c838ea$4d090a80$6701a8c0@itasoftware.com> From: "Allen, Brandon" To: , X-archive-position: 3788 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Brandon.Allen@OneNeck.com Precedence: normal Reply-to: Brandon.Allen@OneNeck.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 Thanks for the update. I just ran counts of the "wrong results" bug fixes in all patchsets from 9.2.0.2 to 10.2.0.4 and 10.2.0.4 is the highest by far with 180! So, I think it's not just our imagination that the software is getting buggier as complexity increases (this was discussed in another thread recently). Maybe Oracle will get to the point some day of offering a stripped down version for all of us that don't need the extra functionality and just want reliability and consistency. Well, I guess we do still have the option of running 8.1.7.4 since it's under Lifetime Sustaining Support :-) -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Henry Poras There are a number of bugs listed in metalink associated with this feature (just search on _optimizer_filter_pred_pullup). Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. -- http://www.freelists.org/webpage/oracle-l