$ guides / oracle-database / oracle-database-buffer-cache-hit-ratio ▌

Operations Guides

Oracle buffer cache hit ratio: the most misused metric in Oracle monitoring

The buffer cache hit ratio appears in nearly every legacy monitoring template, executive dashboard, and database health report. It is also one of the least useful signals for diagnosing real production problems.

The Oracle V$SYSSTAT formula is 1 - (physical reads cache / (consistent gets from cache + db block gets from cache)), computed from cumulative counters. A high percentage looks reassuring. A low percentage looks alarming. Neither reaction is reliably correct. A system doing nothing but SELECT * FROM dual in a loop has a 99.99% hit ratio and zero useful work. A system running large parallel analytics might sit at 70% and be performing exactly as designed.

Oracle’s performance methodology has de-emphasized hit ratios since 10g in favor of wait-event analysis: identify where sessions spend time, then address the dominant wait.

What it measures

The buffer cache hit ratio measures the percentage of logical reads satisfied from the SGA buffer cache without requiring physical I/O. Logical reads are the sum of db block gets (current-mode reads, typically DML) and consistent gets (query-mode reads, typically SELECT). Physical reads are block reads from datafiles into the cache.

Treat this as a LOW severity signal. Classify it as INFO, escalating to a ticket only if a sudden drop exceeding 10 percentage points correlates with measurable performance degradation. The ratio is a contextual signal, never a primary diagnostic.

It matters as a topic because teams continue to build alerting and capacity decisions around it. Threshold-based alerts on absolute values (page if below 95%) generate noise on warehouse systems and miss real problems on OLTP systems. Decisions to increase DB_CACHE_SIZE based on a declining ratio often waste memory without addressing the actual bottleneck.

How it works

Every block access through the buffer cache is a logical read. The server process checks the buffer cache first. If the block is present, the read completes without disk I/O. If the block is absent, the process issues a physical read into the cache, then completes the logical read. The hit ratio captures the proportion of logical reads that did not require that physical read.

The mechanism breaks down when direct-path reads enter the picture.

flowchart TD
    A["Logical read request"] --> B{"Block in buffer cache?"}
    B -->|"Yes: cache hit"| C["No physical I/O
db block gets / consistent gets"]
    B -->|"No: cache miss"| D["Physical read into cache
physical reads"]
    E["Large segment full scan
serial direct path 11g+"] --> F["Direct path read
physical reads direct
bypasses buffer cache"]
    C --> G["Counted in hit ratio"]
    D --> G
    F --> H["Not reflected in
buffer cache hit ratio"]

Direct-path reads bypass the buffer cache entirely. Starting in 11g, Oracle can choose serial direct-path reads for full scans of large segments, reading blocks directly into PGA instead of the SGA. These reads appear in physical reads direct, not in db block gets or consistent gets. Parallel queries, direct-path loads, LOB reads, and temp file reads also bypass the cache.

Oracle documents physical reads as all data blocks read from disk; it can be greater than physical reads direct plus physical reads cache because process-private buffer reads are included. physical reads cache is the subset read into the buffer cache, while physical reads direct bypasses the buffer cache. Therefore, use Oracle’s cache-specific numerator and cache-specific logical-read denominators for the buffer cache hit ratio. When direct-path I/O is significant, do not substitute the aggregate physical reads statistic into that formula: it will inflate the denominator mismatch and depress the apparent cache ratio. The metric does not tell you whether physical I/O is actually a bottleneck.

Where it shows up in production

The hit ratio appears in different contexts, and its meaning shifts with workload type.

OLTP systems. Typical ratios exceed 95%. The working set (hot index blocks, frequently accessed rows) fits largely in cache. A declining trend over weeks may indicate working-set growth, but it does not tell you whether that growth matters. Correlate with db file sequential read wait time. If average single-block read latency is stable and within storage capability, the declining ratio is informational, not actionable.

Data warehouse and analytics systems. Ratios of 70-80% are normal and expected. Large full scans read blocks once and do not reuse them, so caching them provides no benefit. A 99% ratio on a warehouse system might indicate that scans are unexpectedly going through the cache and polluting it rather than using direct path. That is worse, not better.

After instance restart. The buffer cache is empty. Expect 5-30 minutes of elevated physical I/O and depressed hit ratios while the cache warms. This is normal cold-start behavior, not a problem.

During batch windows. Batch analytics displace OLTP cached data. The ratio drops during the batch window and recovers after. Some shops run batch on an Active Data Guard standby or use KEEP/RECYCLE buffer pools to isolate OLTP hot blocks from scan traffic.

Plan regressions. When the optimizer switches a high-frequency query from an index scan to a full table scan, logical reads spike. If the scan goes through the cache, the hit ratio may drop (more physical reads relative to logical reads). If the scan goes direct path, the hit ratio may stay high while physical I/O and latency spike. Either way, the hit ratio does not identify the regression. The db file scattered read wait event and per-SQL BUFFER_GETS / EXECUTIONS from V$SQL do.

Common misuses

Alerting on absolute thresholds. A static rule like “alert if hit ratio below 95%” fires constantly on warehouse systems and never fires on a broken OLTP system where all sessions are blocked on enq: TX - row lock contention but the cache ratio is still 99%. The ratio measures cache efficiency, not system health. A system can have a 99.9% hit ratio and be completely non-functional.

Using it to size the buffer cache. A declining ratio does not necessarily mean that increasing the buffer cache will help. If the working set is growing because of a plan regression (a query now does a full scan instead of an index lookup), adding cache memory treats a symptom while the disease worsens. Fix the SQL plan first.

Comparing it across systems. A 90% ratio on one system might be excellent. On another, it might indicate a problem. The ratio is workload-dependent. Cross-system comparison without workload context is meaningless.

Ignoring cumulative counter behavior. The V$SYSSTAT counters are cumulative since instance startup. A system that has been up for a year has enormous counters. The ratio reflects the entire uptime, not the current state. A rate-based version computed from deltas over a short interval is more useful for detecting changes, but even then, it remains a secondary signal.

What to use instead

Oracle’s primary diagnostic framework is wait events. Every session is either ON CPU or waiting for something. The views V$SESSION_EVENT, V$SYSTEM_EVENT, and V$ACTIVE_SESSION_HISTORY expose this. Wait times, not hit ratios, tell you where time is being spent.

The fastest triage query during an incident:

-- Dominant wait class among active non-idle sessions
SELECT NVL(WAIT_CLASS, 'ON CPU') AS wait_class, COUNT(*) AS sessions
FROM V$SESSION
WHERE STATUS = 'ACTIVE' AND TYPE = 'USER' AND WAIT_CLASS != 'Idle'
GROUP BY NVL(WAIT_CLASS, 'ON CPU')
ORDER BY COUNT(*) DESC;

This tells you immediately whether the problem is Commit (redo latency), User I/O (storage), Concurrency (locks and latches), Application (enqueue waits), or CPU. No hit ratio provides this information.

For commit latency specifically, check log file sync and compare it with log file parallel write:

-- Compare client-perceived commit wait vs LGWR actual I/O time
SELECT EVENT,
       ROUND(TIME_WAITED_MICRO / NULLIF(TOTAL_WAITS, 0) / 1000, 2) AS avg_ms
FROM V$SYSTEM_EVENT
WHERE EVENT IN ('log file sync', 'log file parallel write');

If log file sync averages 50ms while the hit ratio is 99%, the hit ratio told you nothing about the real problem.

For plan regression detection, track per-execution metrics:

-- Top SQL by logical reads per execution
SELECT SQL_ID, PLAN_HASH_VALUE, EXECUTIONS,
       ROUND(BUFFER_GETS / NULLIF(EXECUTIONS, 0)) AS gets_per_exec,
       ROUND(ELAPSED_TIME / NULLIF(EXECUTIONS, 0) / 1000) AS ms_per_exec
FROM V$SQL
WHERE EXECUTIONS > 0
ORDER BY BUFFER_GETS / NULLIF(EXECUTIONS, 0) DESC
FETCH FIRST 20 ROWS ONLY;  -- 12c+ syntax; use ROWNUM <= 20 on 11g

A query whose gets_per_exec jumps from 10 to 1,000,000 is a plan regression. The hit ratio will not surface this. V$SQL will.

Signals to watch in production

Signal	Why it matters	Warning sign
Top 5 wait events by time waited	Tells you where DB time is actually spent	`log file sync` or `enq: TX` dominating on OLTP
Average active sessions vs CPU cores	Primary load indicator; comparable to Linux load average but ASH-based	Active sessions sustained at more than 2x core count
`log file sync` average wait	Commit latency; the most common Oracle performance emergency	More than 5ms on SSD, more than 20ms on SAN
`db file sequential read` average wait	Single-block index read latency; buffer cache miss indicator	More than 10ms on SSD sustained
`db file scattered read` total time	Full-scan activity; plan regression indicator on OLTP	Dominating wait time on an OLTP system
Buffer gets per execution for top SQL	Plan regression detection	More than 10x increase from baseline
Physical reads rate (delta-computed)	Actual storage I/O pressure, including direct-path	Rising while logical reads are stable

How Netdata helps

Per-second collection of Oracle wait events, active session counts, and I/O latency catches transient contention that minute-sample monitoring misses.
Correlating log file sync spikes with OS-level disk latency on the redo device distinguishes storage problems from LGWR scheduling problems in seconds, not hours.
Anomaly detection on average active sessions and top wait-event time flags deviations from the baseline without requiring static thresholds on workload-dependent metrics.
Trend views on buffer gets per execution for top SQL_IDs surface plan regressions before they become page-level incidents.
The buffer cache hit ratio, if collected, appears as contextual information alongside the signals that actually drive decisions.

See Oracle Database monitoring with Netdata for per-second wait-event collection and anomaly detection.

The Netdata solution

Oracle Database monitoring with Netdata

Netdata monitors Oracle Database with per-second metrics and automatic dashboards. Watch wait events, redo and archive-log activity, tablespace and undo space, and session and lock activity so the failure modes in these runbooks surface before the instance hangs.

See Oracle monitoring → Start monitoring free