Oracle Result Cache statistics
<p>I am using <code>/*+ result_cache */</code> optimizer hint as well <code>RESULT_CACHE</code>in my function.
When i run the query:</p>

<pre><code>select * from v$result_cache_objects;
</code></pre>

<p>i can see that my objects are present in cache but i want to know hit and miss stats. Like how many queries were fired, how many hit cache and how many missed it.
Is there a way that i get these details?</p>