Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Query capture

Re: Query capture

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Thu, 07 Apr 2005 13:06:11 -0600
Message-ID: <425584A3.9020705@centrexcc.com>


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
Received on Thu Apr 07 2005 - 15:10:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US