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: stephen booth <stephenbooth.uk_at_gmail.com>
Date: Thu, 7 Apr 2005 20:28:51 +0100
Message-ID: <687bf9c405040712283b6df9c@mail.gmail.com>


On Apr 7, 2005 8:06 PM, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:

> 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

Actually it was just a case that it worked when I tried it and so it didn't occur to me that another Oracle instance might evaluate the where clause in a different order. Oh well, we live and learn.

Stephen

-- 
It's better to ask a silly question than to make a silly assumption.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 07 2005 - 18:14:38 CDT

Original text of this message

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