On 6/5/23 03:45, Nenad Noveljic wrote:
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.
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