RE: dictionary misses

Ruth,

the hitratio for dictionary objects must be very high, you must be aiming at 98% at least, so the misses may not exceed 2%.

Regards, Richard Klavers

> ----------
> Van: Ruth Gramolini[SMTP:rgramolini_at_tax.state.vt.us]
> Antwoord naar: ORACLE-L_at_fatcity.com
> Verzonden: maandag 22 mei 2000 16:46
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp: 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
>
>
> --
> Author: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon May 22 2000 - 10:25:44 CDT