Home -> Usenet -> comp.databases.oracle -> CacheHitRatio - Any good SQL?

CacheHitRatio - Any good SQL?

From: Roy deCarvalho <roy_at_sol.acs.unt.edu>
Date: 1996/09/17
Message-ID: <51n3t9$845_at_hermes.acs.unt.edu>#1/1 







I kept getting an alarm on Cache Hit Ratio from our monitoring software
called Patrol. I have no access to this software from home. I wonder if 
anyone has a good tool that they are willing to share to monitor Cache
Hit Ratio. I usually just issue:


	SQL> SELECT SUM(gets)  "Data Dictionary Gets",
            2  SUM(getmisses) "Data Dic Cache Get Miss"
            3  FROM v$rowcache;




And then calculate the ratio by hand.



Thanks for your time.



Roy


--


Received on Tue Sep 17 1996 - 00:00:00 CEST












Original text of this message