Database Tuning (MOSC)

MOSC Banner

How to explain the case that the value of "Library Cache Hit Ratio" in V$METRICNAME is larger than 1

edited Jul 31, 2017 4:51PM in Database Tuning (MOSC) 6 commentsAnswered

When I query the Library Cache Hit Ratio using view v$metric_history, the result is larger than 100%.

SQL> select sum(a.value)/count(*) pct from v$metric_history a where a.metric_name = 'Library Cache Hit Ratio' and group_id = 2 and a.begin_time >= sysdate - 1 and a.end_time < sysdate;

       PCT

----------

100.153536

How to explain it?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center