Re: Query capture

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Thu, 07 Apr 2005 12:08:21 -0600
Message-ID: <42557715.5030603@centrexcc.com>

Yes, I was wondering about that. I always use "elapsed_time/greatest(executions,1)" to avoid division by zero problems.

Mohammad Rafiq wrote:

> Stephen
>
> Are you sure it ran successfully? I got error on a 9206 database on W2000.
> Regards
> and (a.elapsed_time/(1000000*a.executions)) > 5
> *
> ERROR at line 9:
> ORA-01476: divisor is equal to zero
>

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 07 2005 - 14:12:18 CDT