Message-Id: <10534.109818@fatcity.com> From: "karim" Date: Tue, 20 Jun 2000 12:24:21 +0300 Subject: negative 'consistent gets' value 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