DataBase Buffer Cache Hit Ratio (ORACLEJAVA커뮤니티)

Buffer Cache Hit Ratio

rem
rem  This script uses PL/SQL.
rem  le hit ratio 
rem
 
col global_name for A20 
variable d number 
variable c number 
variable r number 
begin 
  select value into :c 
  from v$sysstat 
  where name = 'consistent gets'; 
  select value into :d 
  from v$sysstat 
  where name = 'db block gets'; 
  select (1- value/( :c + :d)) into :r   
  from v$sysstat 
  where name in ( 'physical reads'); 
 
end; 
/

After creating the procedure, use the following select statement
to retrieve current results.
 
SQL> select  global_name, :r "Hit Ratio" from  global_name ;
 
    GLOBAL_NAME  Hit Ratio
    -----------  ----------
    V920.WORLD    .995129671

[출처] 오라클자바커뮤니티 - http://www.oraclejavanew.kr/bbs/board.php?bo_table=LecOrccleTun&wr_id=31