RE: dictionary misses

Hi Ruth,

It depends on whether you use synonyms.
If you don't use ANY synonyms, then hit rates of 99% can be seen. If you do, then the hit rates can be very low.

Note also that it is the library cache hit rate that you should focus on, not the dictionary cache one. The dictionary cache is used merely to load the library cache if you get a miss there.
(OK, that's an over-statement because it ignores the locking functionality, but you get the idea).

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/


-----Original Message-----
From:	Ruth Gramolini [SMTP:rgramolini_at_tax.state.vt.us]
Sent:	Tuesday, May 23, 2000 12:46 AM
To:	Multiple recipients of list ORACLE-L
Subject:	dictionary misses

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