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;