1.查看缓冲池命中率

select 1 - ((physical.value - direct.value - lobs.value) / logical.value) "Buffer Cache Hit Ratio"
  from v$sysstat physical,
       v$sysstat direct,
       v$sysstat lobs,
       v$sysstat logical
 where physical.name = 'physical reads'
   and direct.name = 'physical reads direct'
   and lobs.name = 'physical reads direct (lob)'
   and logical.name = 'session logical reads';

Buffer Cache Hit Ratio
----------------------
            .989871314

2.查询Oracle数据字典缓存命中率：

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

3.查询Oracle的latch命中率：http://www.cndba.cn/hbhe0316/article/107879

select 1-sum(misses)/sum(gets) from v$latch;
1-SUM(MISSES)/SUM(GETS)
-----------------------
             .998616454

4.查看Oracle的buffer pool命中率： http://www.cndba.cn/hbhe0316/article/107879http://www.cndba.cn/hbhe0316/article/107879http://www.cndba.cn/hbhe0316/article/107879http://www.cndba.cn/hbhe0316/article/107879

SELECT NAME, PHYSICAL_READS, DB_BLOCK_GETS, CONSISTENT_GETS,
      1 - (PHYSICAL_READS / (DB_BLOCK_GETS + CONSISTENT_GETS)) "Hit Ratio"
  FROM V$BUFFER_POOL_STATISTICS;
NAME                                                                             PHYSICAL_READS DB_BLOCK_GETS CONSISTENT_GETS  Hit Ratio
-------------------------------------------------------------------------------- -------------- ------------- --------------- ----------
DEFAULT                                                                                 4039839      38772967       217740587 .984250973

5.查看共享池的命中率：

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

Elapsed: 00:00:00.01

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle