Re: CacheHitRatio - Any good SQL?

Roy deCarvalho wrote:
>
> 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
>
> --Roy,

You'll find SQL command files utlbstat.sql and utlestat.sql in your $ORACLE_HOME/rdbms/admin directory. They are specifically designed for performance monitoring and tuning.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.