|
[oracle-l]
||
[Date Prev]
[01-2006 Date Index]
[Date Next]
||
[Thread Prev]
[01-2006 Thread Index]
[Thread Next]
Re: Divisor is equal to zero
- From: Li-Shan Cheng <exriscer@xxxxxxxxx>
- To: onkarnath.tiwary@xxxxxxxxx
- Date: Wed, 4 Jan 2006 09:09:08 +0100
what is the value of a.value+b.value?
On 1/4/06, Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx> wrote:
>
> Hi,
>
> WISH YOU ALL A VERY HAPPY NEW YR.
>
> To find the buffer hit ratio, when I executed the following query its
> giving me one error "
> (a.value+b.value))
> *
> ERROR at line 4:
> ORA-01476: divisor is equal to zero
> "
> The query is :
> "column "logical_reads" format 99,999,999,999
> column "phys_reads" format 999,999,999
> column "phy_writes" format 999,999,999
> select a.value + b.value "logical_reads",
> c.value "phys_reads",
> round(100 * ((a.value+b.value)-c.value) /
> (a.value+b.value))
> "BUFFER HIT RATIO"
> from v$sysstat a, v$sysstat b, v$sysstat c
> where
> a.statistic# = 38
> and
> b.statistic# = 39
> and
> c.statistic# = 40;"
>
> ????????
>
> --
> Thanks & Regards,
> T. Onkar Nath
> OneAPPS Enterprise Technology Pvt. Ltd.
> to_onkar@xxxxxxxxx
> onkarnath.tiwary@xxxxxxxxx
>
>
|
|
