Re: Cursor cache hit ratio over 100%

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_NAMEVALUE METRIC_UNIT
>
> ----------------------------------------------------------------
> ----------
> ----------------------------------------------------------------
>
> Cursor Cache Hit Ratio110 % 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-1217
https://dbwhisperer.wordpress.com

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