Database Tuning (MOSC)

MOSC Banner

How is Flash Cache Hit % calculated ?

edited Aug 3, 2017 10:53AM in Database Tuning (MOSC) 5 commentsAnswered

Hello,

When I see AWR to check if the DB Flash Cache is used, the "Flash Cache Hit %" metric is always 0 but there are some "db flash cache single block physical read":

I don't understand why the "Flash Cache Hit %" is 0 if at the same time there are some reads from the db flash cache.

Thanks for your help,

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