| Dictionary Cache Hit ratio [message #351698] |
Thu, 02 October 2008 09:24  |
shrinika
Messages: 306
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
