From oracle-l-bounce@freelists.org Thu Apr 7 15:10:23 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j37KAMgC028896 for ; Thu, 7 Apr 2005 15:10:22 -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 j37KAJem028890 for ; Thu, 7 Apr 2005 15:10:22 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 707BA925A0; Thu, 7 Apr 2005 14:08:02 -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 04472-03; Thu, 7 Apr 2005 14:08:02 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DA3A892664; Thu, 7 Apr 2005 14:08:01 -0500 (EST) Message-ID: <425584A3.9020705@centrexcc.com> Date: Thu, 07 Apr 2005 13:06:11 -0600 From: Wolfgang Breitling Organization: Centrex Consulting Corporation User-Agent: Mozilla Thunderbird 0.7.2 (Windows/20040707) X-Accept-Language: en-us, en MIME-Version: 1.0 To: stephenbooth.uk@gmail.com Cc: Mohammad Rafiq , oracle-l@freelists.org Subject: Re: Query capture References: <42556441.6030401@centrexcc.com> <28ae33f105040711022248b29d@mail.gmail.com> <42557715.5030603@centrexcc.com> <687bf9c40504071146194a1da1@mail.gmail.com> In-Reply-To: <687bf9c40504071146194a1da1@mail.gmail.com> Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-UCIT-MailScanner-Information: Please contact IT Help Desk at (403) 220-5555 for more information X-UCIT-MailScanner: Found to be clean X-UCIT-MailScanner-From: breitliw@centrexcc.com X-archive-position: 18194 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: breitliw@centrexcc.com Precedence: normal Reply-To: breitliw@centrexcc.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: Stephen, The old problem. You are relying on a specific order of execution of the predicates. Oracle is perfectly in its right to calculate (a.elapsed_time/(1000000*a.executions)) > 5 before a.executions > 0 after all, "and" is commutative. stephen booth wrote: > > > I ran it on 9206 on Solaris. That error is basically saying that > a.executions=0. Thing is the preceding part of the where clause is > a.executions>0 so there should be no way a.executions=0. The only > thing that comes to mind is that Oracle is trying to evaluate the > "(a.elapsed_time/(1000000*a.executions)) > 5" before the "a.executions > -- Regards Wolfgang Breitling Centrex Consulting Corporation www.centrexcc.com -- http://www.freelists.org/webpage/oracle-l