Limits of Cache Fusion in Reducing Buffer Cache Contention for Large Tables in Oracle RAC 19c
Goal Determine whether Cache Fusion reliably lowers query latency for concurrent read‑only workloads on large tables (>10 GB) in a two‑node Oracle RAC 19c environment, given that documentation notes potential benefits while empirical results show variability. Constraints include a read‑heavy OLAP pattern, default 8 KB block size, automatic memory manageme