|
[oracle-l]
||
[Date Prev]
[01-2006 Date Index]
[Date Next]
||
[Thread Prev]
[01-2006 Thread Index]
[Thread Next]
Divisor is equal to zero
- From: Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 4 Jan 2006 11:26:23 +0530
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
|
|
