Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Is it strange ?

Is it strange ?

From: Maui <mmunarin_at_venicecom.it>
Date: Thu, 18 Oct 2001 12:44:07 +0200
Message-ID: <9qmaj5$i1i$1@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 - 05:44:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US