High Buffer Cache Hit(%) Metric Bigger Than 100 (Doc ID 1164233.1)

Last updated on JULY 22, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Enterprise Manager Base Platform - Version 10.2.0.1 to 11.1.0.1 [Release 10.2 to 11.1]
Information in this document applies to any platform.

Symptoms

Target =  Database 10.2.0.3

The High Buffer Cache Hit(%) Average shows bigger then 100% and should be less or equal to 100.

select to_char(ROLLUP_TIMESTAMP,'mm-dd-yyyy hh24:mi:ss'), average, minimum, maximum, sample_count from
mgmt$metric_hourly
where
metric_column = 'bufcachehit_pct' and
metric_name='instance_efficiency'
and TARGET_NAME= 'DB_DB1'
and TRUNC(ROLLUP_TIMESTAMP) between TO_DATE('21-JUN-2010','DD-MON-YYYY') and TO_DATE('27-JUN-2010','DD-MON-YYYY');

shows values like :

06-23-2010 02:00:00 12356.2672 56.152931 147300 12
.
06-26-2010 22:00:00 574.609165 98.42209 5800 12
.
06-27-2010 05:00:00 2783456.74 66.950549 33400400 12

..




Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms