Re: Cursor cache hit ratio over 100%

A comment by Martin Maletinsky on an old blog note of mine MIGHT be the answer (or part of the answer) to this question. I haven't tried repeating his tests on a recent version of Oracle, though: https://jonathanlewis.wordpress.com/2007/07/03/parse-calls/#comment-39792

Regards
Jonathan Lewis

On Mon, 5 Jun 2023 at 08:46, Nenad Noveljic <nenad.noveljic_at_gmail.com> 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
>

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