Re: Query capture
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: Mohammad Rafiq <rafiq9857@xxxxxxxxx>
- Date: Thu, 07 Apr 2005 12:08:21 -0600
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
