/* ************************************************ */
/*                                                  */
/* Script: Display data dictionary hit ratio        */
/*                                                  */
/* name:    @c:\oracle\sql\v$rowcache.sql            */
/* date:    24-AUG-95                               */
/* creator: Rick Kupcunas                           */
/*                                                  */
/* ************************************************ */

set pagesize 65;
set linesize 80;

select 	sum(gets) "DD Hits",
  	sum(getmisses) "DD Misses",
	(sum(getmisses)/sum(gets))*100 "Ratio"
  from v$rowcache;

commit;

