Thanks to all who replied. I just couldn't remember. Brain cramp or senior
moment I guess. Ruth
----- Original Message -----
From: Rocky Welch <rockyw_99_at_yahoo.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Monday, May 22, 2000 12:15 PM
Subject: Re: dictionary misses
> Hi Ruth,
> I think < 10% is a good number.
>
> --- 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).
>
>
> =====
> Rocky Welch
> Oracle DBA Consultant
>
> rockyw_99_at_yahoo.com
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
> --
> Author: Rocky Welch
> INET: rockyw_99_at_yahoo.com
>
> 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 - 12:52:14 CDT
