Re: Is it strange ?

In article <9qmaj5$i1i$1_at_fe2.cs.interbusiness.it>, "Maui" says...
>
>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;
>

that should be:

  1 SELECT (1-(SUM(GETMISSES)/SUM(gets)))*100   2 "Dictionary Cache Hit Ratio"
  3* FROM V$ROWCACHE sum(gets) -- NOT count.

>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.
>
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp