Home » RDBMS Server » Performance Tuning » Dictionary Cache Hit ratio (Oracle 9.2.0.8)
Dictionary Cache Hit ratio [message #351698] Thu, 02 October 2008 09:24 Go to next message
shrinika
Messages: 266
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.

SELECT (SUM(GETMISSES)/(SUM(GETS)+SUM(GETMISSES))) * 100
FROM
V$ROWCACHE;


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.

http://oracle.ittoolbox.com/documents/popular-q-and-a/cache-hit-ratios-2348

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"
FROM V$ROWCACHE


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

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


Current Time: Fri Dec 09 15:27:16 CST 2016

Total time taken to generate the page: 0.15903 seconds