negative 'consistent gets' value

From: karim <fahdkrm_at_yahoo.com>
Date: Tue, 20 Jun 2000 12:24:21 +0300
Message-Id: <10534.109818@fatcity.com>

hello ,

I check my database cache hit ratio using the query:

select name,value from v$sysstat
where name in ('physical reads','consistent gets','db block gets')

the result :

db block gets                      10885242
consistent gets                  -1,855E+09
physical reads                     86457171

the 'consistent gets' is negative !! the hit ratio will be 104% whats the problem ?
we have oracle 7 under openVMS.

thanx

---

Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com Received on Tue Jun 20 2000 - 04:24:21 CDT