Your formula is off. Try dividing by the sum(gets).
" <mmunarin_at_venicecom.it> wrote in message news:<9qmaj5$i1i$1_at_fe2.cs.interbusiness.it>...
> Hi all,
> i'm a beginerr DBA and I've encountered something strange tuning my DB
> Server.
> When I executed this statement
>
> SELECT (1-(SUM(GETMISSES)/SUM(COUNT)))*100
> "Dictionary Cache Hit Ratio"
> FROM V$ROWCACHE;
>
> the result was -3534,76363636364 !!!!
> I think there is an error in the statement, but i've found it on a Oracle
> Manual !!
> The "Dictionary cache" should be at least 90% for a DSS Sytem, so why i got
> this value ?
>
> Thanks a lot to everyone!
> Bye.
>
> --
> Munarin Mauro - DBA
> VeniceCom S.r.l. - Internet Business Solutions
> Via Vespucci 7, 30173 Venezia Mestre
> Tel.041 612 767 - Fax 041 612 263
> http://www.venicecom.it
>
>
>
> *************Internet Email Confidentiality Footer*************
>
> Private and/or confidential information may be contained in this e-mail
> message. If you are not the addressee indicated in this message you may not
> copy or forward this message to anyone. In such case, you should destroy
> this message and kindly notify the sender by replying this email. Please
> advise immediately if you or your employer does not consent to use Internet
> email for messages of this kind. Opinions, conclusions and other
> information in this message that do not relate to the official business of
> my company shall be understood as neither given nor endorsed by it.
Received on Thu Oct 18 2001 - 08:27:53 CDT
