Data Dictionary Hit Ratio - myth or fact?

From: Tony Sequeira <>
Date: Tue, 18 Mar 2008 09:12:56 +0000
Message-Id: <1205831576.4435.21.camel@comet.sequestor.lan>

I help support a Database running on MS Windows Server 2003 SP1.

Someone has some old performance scripts that displays the data dictionary hit ratio amongst others. This comes in in the mid to high 80s. The BCHR on this system is high 90s.

I have received a request to sort this out.

Data Dictionary Hit Ratio should be > 90% Check Oracle Memory assignment.

I am aware of the BCHR and the arguments against using it, but I cannot find anything specific on the DDHR. I'm thinking of sending them a link to Kolk's YAPP Method.

Any pointers?

Of course, they may be right, and this may need addressing.

S. Anthony Sequeira

Take everything in stride. Trample anyone who gets in your way.
Received on Tue Mar 18 2008 - 04:12:56 CDT

Original text of this message