Home

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

Database Buffer Cache Hit Ratio

0 Comments

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 : 1/20/2014 by Anuj
 
Comments
No comment found.
 


Add Your Comments
 
Name :
Email :
Comments :

 

 
 
  Archives
 
  Recent Posts

IOUG Collaborate 17
Posted on :   3/25/2017

Create Oracle Database 12c R2 (12.2) in Cloud in around 1 hour
Posted on :   11/13/2016

Changing sysman password in EM cloud control 12c
Posted on :   11/9/2016

  Recent Comments
 

Home  |  About Me  |  Contact  |  Oracle12cSIG(IOUG)

All Rights Reserved 2013 Oracle-12c