Buffer Cache Hit Ratio

最新推荐文章于 2021-02-07 06:19:03 发布

weixin_33862041

最新推荐文章于 2021-02-07 06:19:03 发布

阅读量158

点赞数

原文链接：https://my.oschina.net/huayd/blog/138878

版权

为什么80%的码农都做不了架构师？>>>

计算整个buffer cache的hit ratio:

-- Calculating the Buffer Cache Hit Ratio

SELECT NAME, VALUE
  FROM V$SYSSTAT
WHERE NAME IN ('db block gets from cache', 'consistent gets from cache', 'physical reads cache');

-- Using the values in the output of the query, calculate the hit ratio for the buffer cache with the following formula:
   1 - (('physical reads cache') / ('consistent gets from cache' + 'db block gets from cache'))

计算每一个buffer pool(default,keep,recycle)的hit ratio:

The data in V$SYSSTAT reflects the logical and physical reads for all buffer pools within one set of statistics. To determine the hit ratio for the buffer pools individually, query the V$BUFFER_POOL_STATISTICS view. This view maintains statistics for each pool on the number of logical reads and writes.

-- The buffer pool hit ratio can be determined using the following formula:
   1 - (physical_reads/(db_block_gets + consistent_gets))

-- The ratio can be calculated with the following query:

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