From oracle-l-bounce@freelists.org Fri Apr 2 16:19:26 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i32MJPU05380 for ; Fri, 2 Apr 2004 16:19:25 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i32MJOo05372 for ; Fri, 2 Apr 2004 16:19:25 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CCF5E63508E; Fri, 2 Apr 2004 17:15:32 -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 06219-92; Fri, 2 Apr 2004 17:15:32 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2EA01634FE5; Fri, 2 Apr 2004 17:15:32 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 02 Apr 2004 17:14:23 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C8FB3634F08 for ; Fri, 2 Apr 2004 17:14:22 -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 05962-79 for ; Fri, 2 Apr 2004 17:14:22 -0500 (EST) Received: from rtsiexch.kennecott.riotinto.org (mail.kennecott.com [148.175.49.253]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 319DE634EEF for ; Fri, 2 Apr 2004 17:14:22 -0500 (EST) Received: from rtsiexch00.kennecott.riotinto.org ([148.175.33.10]) by rtsiexch.kennecott.riotinto.org with Microsoft SMTPSVC(5.0.2195.6713); Fri, 2 Apr 2004 15:22:59 -0700 X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: RE: The Oracle 9.2.0.4 Optimizer - are there problems with it? Date: Fri, 2 Apr 2004 15:22:59 -0700 Message-ID: <9ACD42A615C4F1419122D16AB1C718DE53784E@rtsiexch00.kennecott.riotinto.org> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: The Oracle 9.2.0.4 Optimizer - are there problems with it? Thread-Index: AcQY/7DLd8TzjndgSxK2aMenbwgV8AAAUE8w From: "Wales, Stephen (RTSI)" To: X-OriginalArrivalTime: 02 Apr 2004 22:22:59.0275 (UTC) FILETIME=[0DF099B0:01C41901] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2483 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Stephen.Wales@riotinto.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Haven't yet - going to continue as is I think and see what else shakes=20 out of the "inefficient query" tree, but that's a thought for future=20 reference.... Steve -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Juan Cachito Reyes Pacheco Sent: Friday, April 02, 2004 3:09 PM To: oracle-l@freelists.org Subject: Re: The Oracle 9.2.0.4 Optimizer - are there problems with it? Did you tried setting OPTIMIZER_FEATURES_ENABLE to 9.2.0.3 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------