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: Christo Kutrovsky <kutrovsky.oracle_at_gmail.com>
Date: Thu, 7 Apr 2005 16:57:58 -0400
Message-ID: <52a152eb0504071357307e9504@mail.gmail.com>


I usually use nullif(executions,0).

Christo

On Apr 7, 2005 3:06 PM, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
> 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
>

-- 
Christo Kutrovsky
Database/System Administrator
The Pythian Group
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 07 2005 - 18:46:29 CDT

Original text of this message

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