Hotsos Home Page

Document Properties

Title: Why a 99%+ Database Buffer Cache Hit Ratio is Not Ok
Author: Cary Millsap
Get File:
Abstract: Many tuning professionals and textbook authors sell advice encouraging their customers to enjoy the performance virtues of Oracle database buffer cache hit ratios that approach 100%. However, database buffer cache hit ratio is not a reliable system performance metric. Buffer cache hit ratios above 99% usually indicate particularly serious SQL inefficiencies. Repairs of these inefficiencies often yield 100x or greater performance improvements, yet the optimizations result in reduced database buffer cache hit ratios. This paper shows why a 99%+ buffer cache hit ratio almost always signals performance inefficiencies, including real-life examples. It shows how to detect the inefficiencies and how to repair them. It concludes with recommendations about what metrics the performance analyst should use instead of the venerable but unreliable database buffer cache hit ratio.
Document type: article
Updated: Wed 15 Oct 2003 (10.5 years ago)
File size: 238,824 bytes
MD5 checksum: aca9d3856d0eaca2362e9f3edbca2160
File type: .pdf
Authentication: registered — Registered guest (free registration)