FreeLists / oracle-l / Re: Divisor is equal to zero

[Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>]

What Oracle version?

select b.statistic#, b.name, a.value
from v$sysstat a, v$statname b
where a.statistic# = b.statistic#
and b.statistic# between 38 and 40

Oracle 8.1:

STATISTIC# NAME                                          VALUE
---------- ---------------------------------------- ----------
        38 db block gets                                   297
        39 consistent gets                               45015
        40 physical reads                                39134

Oracle 9.2:

STATISTIC# NAME                                VALUE
---------- ------------------------------ ----------
        38 gcs messages sent                       0
        39 ges messages sent                       0
        40 db block gets                        4589


Oracle 10.1:

STATISTIC# NAME                                          VALUE
---------- ---------------------------------------- ----------
        38 gcs messages sent                                 0
        39 ges messages sent                                 0
        40 global enqueue CPU used by this session           0

Oracle 10.2:

STATISTIC# NAME                                          VALUE
---------- ---------------------------------------- ----------
        38 physical read total multi block requests       6032
        39 physical read total bytes                8337019904
        40 physical write total IO requests            2667731

The statistic#s change between versions. You can not just take your 
8.1 scripts, run them against another version and expect them to work.

At 10:56 PM 1/3/2006, Onkar N Tiwary wrote:
> 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;"

Regards

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com 

--
http://www.freelists.org/webpage/oracle-l