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: 261
Registered: April 2008
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: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Forget this.
Oracle database is managed by hit ratio.

Previous Topic: Need to improve query performance
Next Topic: Performance Due to Buffer Sort
Goto Forum:

Current Time: Sat Oct 22 19:00:50 CDT 2016

Total time taken to generate the page: 0.08026 seconds