From oracle-l-bounce@freelists.org Fri Mar 5 09:14:25 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i25FEPr01033 for ; Fri, 5 Mar 2004 09:14: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 i25FENo01025 for ; Fri, 5 Mar 2004 09:14:23 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 790D13970C3; Fri, 5 Mar 2004 10:09:12 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 05 Mar 2004 10:08:09 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mail.cybcon.com (mail.cybcon.com [216.190.188.5]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 23FA8396D3C for ; Fri, 5 Mar 2004 09:52:04 -0500 (EST) Received: from dsl2-6 (dsl2-6.cybcon.com [208.186.116.6]) by mail.cybcon.com (8.11.6/8.11.6) with ESMTP id i25Eu7024402 for ; Fri, 5 Mar 2004 06:56:07 -0800 Subject: Re: oracle can ignore hints From: Jared Still To: Oracle-L Freelists In-Reply-To: <40483D31.9060300@optusnet.com.au> References: <20040304184402.TYYI29592.lakemtao03.cox.net@smtp.east.cox.net> <40483D31.9060300@optusnet.com.au> Content-Type: text/plain Message-Id: <1078498659.11030.10685.camel@poirot> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Fri, 05 Mar 2004 06:57:39 -0800 X-CyberConnectics-MailScanner2-Information: Spam/Virus Scanned at CyberConnectics X-CyberConnectics-MailScanner2: Found to be clean X-CyberConnectics-MailScanner2-SpamCheck: X-archive-position: 572 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@cybcon.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l I have had that exact same experience. Two Sun servers, different number of CPU's and RAM, same versions of Oracle 7 down to the patch level, data exported from one database into the other. Strictly RBO, two very different execution paths. Very frustrating, wish I could recall the solution we used. Jared On Fri, 2004-03-05 at 00:41, Kresimir Fabijanic wrote: > Hi Ryan > > What version of Oracle and OS are you running? What hint did you try to > use? How complex was query? > > I have seen a case (OK it was 7.3.4.0 in 1999 on Sun's OS) where two > databases - same version, same OS same Oracle and OS patches on both - > hardware configuration was slightly different (not 100% sure but there > were differences in RAM (1G vs 2G or 4G) and number of CPUs - (2 vs 4) > and some disk layout differences) both databases running RULE (software > vendor requested [Keystone - if you have ever heard of it]) - identical > statement (cut and paste between two terminal sessions (and back)) > generating very different execution plans. > > I tried to verify few times and results were consistently different. > Nothing would surprise me any more. > > Kind regards > > Kresimir Fabijanic > > ryan.gaffuri@cox.net wrote: > > >We had a discussion on here regarding hints. some of you stated that Oracle cannot ignore a proper hint. I have a TAR open and asked about this. Here is the response. > > > > > > > >"A hint simply adds weight to a cost estimation, it can still be overridden by the CBO if the values aren't seen as useful." > > > > > >---------------------------------------------------------------- > >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 > >----------------------------------------------------------------- > > > > > > > > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------