About Me Contact Me Oracle12cSIG(IOUG)
Home  :: Database Buffer Cache Hit Ratio

Database Buffer Cache Hit Ratio


You can run below query to find Database Buffer Cache Hit Ratio

SELECT (P1.value + P2.value - P3.value) / (P1.value + P2.value) "Buffer Cache Hit Ratio" FROM v$sysstat P1, v$sysstat P2, v$sysstat P3 WHERE P1.name = 'db block gets' AND P2.name = 'consistent gets' AND P3.name = 'physical reads';   

Posted on : by Anuj
No comment found.

Add Your Comments
Name :
Email :
Comments :


  Recent Posts

Open world 2018 is on the corner! Are you attending?
Posted on :   9/7/2018

Step by Step Oracle Database 18c Installation on Oracle Linux 6
Posted on :   9/4/2018

APACOUC Session - Oracle 12cR1 was great Oracle 12c R2 is awesome! by Anuj Mohan
Posted on :   9/4/2018

  Recent Comments

Home  |  About Me  |  Contact  |  Oracle12cSIG(IOUG)

All Rights Reserved 2013 Oracle-12c