rem *  **************************************************** *
rem *  name: c:\oracle\sql\cache_02.sql ........            *
rem *                          dictionary cache statistics  *
rem *  owner: R.Kupcunas                                    *
rem *  date:    30-APR-95                                   *
rem *  **************************************************** *

spool cache_02.rslt

set wrap on

set feedback off
set pagesize 60
set heading on
set echo off
set verify off
set pause off
set newpage 0
set term on
set recsep off

/* ****************************** */
/* "Dictionary Cache Statistics"  */
/* ****************************** */


ttitle center 'Dictionary Cache Statistics' skip 2

col parameter heading 'Parameter Name'    format a20   just cent
col getmisses heading 'Get|Misses'        format 9,999,990
col count     heading 'Entries|Allocated' format 9,999,990
col usage     heading 'Entries|Used'      format 9,999,990

select parameter,
       getmisses,
       count,
       usage
  from v$rowcache
  where ((getmisses > count) or
        (usage = count))
  order by 1;

spool off;

commit;
