Re: Cursor cache hit ratio over 100%

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 5 Jun 2023 07:36:46 -0400

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

Other related posts: