dictionary misses

Hi all,

Can anyone tell me the acceptable range for dictionary misses when using this script?
SELECT SUM(getmisses) "Dict Misses",

      SUM(gets) "Requests
     100-(100*(SUM(getmisses)/SUM(gets))) "Hit%",
     100*(SUM(getmisses)/SUM(gets)) "Miss%"
     FROM v$rowcache;

I think I remember it needs be less than 5% but I can't remember.

Thanks in advance,
Ruth B. Gramolini
ORACLE DBA
VT Dept. of Taxes
ph# 802.828.5708
fax# 802.828..3754
rgramolini_at_tax.state.vt.us Received on Mon May 22 2000 - 08:34:11 CDT