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@xxxxxxxxx> 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@xxxxxxxxx>
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
