You are right, the misses should be less than 5%
- Ruth Gramolini <rgramolini_at_tax.state.vt.us> wrote:
> 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).
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
Received on Mon May 22 2000 - 10:04:22 CDT