REM
REM DBAToolZ NOTE:
REM	This script was obtained from DBAToolZ.com
REM	It's configured to work with SQL Directory (SQLDIR).
REM	SQLDIR is a utility that allows easy organization and
REM	execution of SQL*Plus scripts using user-friendly menu.
REM	Visit DBAToolZ.com for more details and free SQL scripts.
REM
REM 
REM File:
REM 	s_sga_dict_cache.sql
REM
REM <SQLDIR_GRP>SGA STATS</SQLDIR_GRP>
REM 
REM Author:
REM 	Vitaliy Mogilevskiy 
REM	VMOGILEV
REM	(www.dbatoolz.com)
REM 
REM Purpose:
REM	<SQLDIR_TXT>
REM	Reports DATA_DICTIONARY_CACHE MISSES TO GETS RATIO
REM	==================================================
REM	sum(get_miss)       
REM	------------- < 15% 
REM	sum(get_reqs)       
REM	</SQLDIR_TXT>
REM Usage:
REM	s_sga_dict_cache.sql
REM 
REM Example:
REM	s_sga_dict_cache.sql
REM
REM
REM History:
REM	08-01-1998	VMOGILEV	Created
REM
REM

ttitle off
btitle off

prompt
prompt Ratio Should be < 15%
prompt 

select sum(getmisses), sum(gets)
,      (sum(getmisses) * 100)/sum(gets)  "Misses To Gets Ratio"
from   v$rowcache
/

select parameter, getmisses, gets
from v$rowcache
/