Re: Cursor cache hit ratio over 100%

Did Connor write a routine to pick your cursor cache hit ratio?

https://connor-mcdonald.com/2017/11/07/buffer-cache-hit-ratio-blast-from-the-past/

On Mon, Jun 5, 2023, 09:51 Ghassan Salem <salem.ghassan_at_gmail.com> wrote:

> There are some very old bugs about this thing. All closed as 'not a bug',
> as it seems that some components, e.g. parts of PL/SQL, increment the
> cursor cache hit count, while not incrementing the parse count, making the
> CC hot ratio become >100.
>
> regards
>
>
> On Mon, Jun 5, 2023 at 1:38 PM Mladen Gogala <gogala.mladen_at_gmail.com>
> wrote:
>
>> On 6/5/23 03:45, Nenad Noveljic wrote:
>>
>> Is there some explanation for Cursor Cache Hit Ratio over 100% or is it a
>> bug?
>>
>>
>> select metric_name, value, metric_unit from v$sysmetric where metric_name
>> = 'Cursor Cache Hit Ratio';
>>
>>
>> METRIC_NAME VALUE METRIC_UNIT
>>
>> ----------------------------------------------------------------
>> ---------- ----------------------------------------------------------------
>>
>> Cursor Cache Hit Ratio 110 % CursorCacheHit/SoftParse
>>
>>
>> Best regards,
>>
>> Nenad
>>
>> Looks like a bug to me. What would 110% cursor hit ratio even mean? 100%
>> means that all cursors the instance opens are in the shared pool. I can't
>> think of any explanation for the 110%, except maybe for the North Korean
>> voting system.
>>
>> Regards
>>
>> --
>> Mladen Gogala
>> Database Consultant
>> Tel: (347) 321-1217https://dbwhisperer.wordpress.com
>>
>>

--
http://www.freelists.org/webpage/oracle-l