Cursor cache hit ratio over 100%
From: Nenad Noveljic <nenad.noveljic_at_gmail.com>
Date: Mon, 5 Jun 2023 09:45:43 +0200
Message-ID: <CAESzRbm4nvBCbgFYCcpMRCvTy+vrubDLdtu0dp+2ZHXop4UEKg_at_mail.gmail.com>
Is there some explanation for Cursor Cache Hit Ratio over 100% or is it a bug?
Date: Mon, 5 Jun 2023 09:45:43 +0200
Message-ID: <CAESzRbm4nvBCbgFYCcpMRCvTy+vrubDLdtu0dp+2ZHXop4UEKg_at_mail.gmail.com>
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-lReceived on Mon Jun 05 2023 - 09:45:43 CEST