Home » RDBMS Server » Performance Tuning » Dictionary Cache Hit ratio (Oracle
Dictionary Cache Hit ratio [message #351698] Thu, 02 October 2008 09:24 Go to next message
Messages: 283
Registered: April 2008
Karma: 0
Senior Member
Hello, I am running the below query in my database for every 30 mins to see the dictionary cache hit ratio.


The output is on averge, it is 0.15.

My questions are,

1. Is this the correct query to find out the dictionary cache hit ratio?

I also found another query from this link.


The below query gives the output as 99.84. I am not sure which one should use.

SELECT (SUM(GETS-GETMISSES))/SUM(GETS) "Dictionary Cache Hit Ratio"

2. When should i increase the shared pool?? Is these(0.15, 99.84) correct value??

Thanks in advance.

[Updated on: Thu, 02 October 2008 09:32]

Report message to a moderator

Re: Dictionary Cache Hit ratio [message #351701 is a reply to message #351698] Thu, 02 October 2008 10:19 Go to previous message
Michel Cadot
Messages: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
Senior Member
Account Moderator
Forget this.
Oracle database is managed by hit ratio.

Previous Topic: Performance Due to Buffer Sort
Next Topic: need assistance to optimize the query
Goto Forum:

Current Time: Tue Aug 22 09:58:53 CDT 2017

Total time taken to generate the page: 0.06310 seconds