查看Oracle数据库命中率

查看Oracle数据库命中率

 

1、查询Oracle数据字典缓存命中率：

select (1-(sum(getmisses)/sum(gets))) * 100 "Hit Ratio" from v$rowcache;

 

2、查询Oracle的latch命中率：

select 1-sum(misses)/sum(gets) from v$latch;

 

3、查看Oracle的buffer pool命中率： 

SELECT NAME, PHYSICAL_READS, DB_BLOCK_GETS, CONSISTENT_GETS,
      1 - (PHYSICAL_READS / (DB_BLOCK_GETS + CONSISTENT_GETS)) "Hit Ratio"
  FROM V$BUFFER_POOL_STATISTICS;

4、查看共享池的命中率：

select SUM(PINHITS)/SUM(PINS) from V$LIBRARYCACHE;