DB 히트율

DB 히트율

Buffer Cache hit Ratio는 아래 쿼리로 조회 가능.

히트율은 90% 이상 권장

  

SELECT name,
       round(((1 - (physical_reads / (consistent_gets + db_block_gets))) * 100),
             2) || '% (90%이상 권장)' "hit Ratio"
  FROM V$BUFFER_POOL_STATISTICS

 WHERE (consistent_gets + db_block_gets) != 0;

.