Here's a query that will give you the hit ratio. The miss rate is just 100 minus the hit rate.
select 1-(PHY.VALUE - LOB.VALUE - DIR.VALUE)/SES.VALUE "CACHE HIT RATIO" FROM V$SYSSTAT SES, V$SYSSTAT LOB, V$SYSSTAT DIR, V$SYSSTAT PHY WHERE SES.NAME ='session logical reads' and DIR.NAME ='physical reads direct' and LOB.NAME ='physical reads direct (lob)' and PHY.NAME ='physical reads';
Dig deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.