Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Is it strange ?
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