dbaplus Community

Sep 26, 2016 · Databases

Oracle 12c Memory Innovations: Smart Flash Cache, PGA Limits & In‑Memory Column Store

This article explains Oracle 12c's key memory‑related enhancements—including the extended database cache (Smart Flash Cache), PGA aggregate limit, In‑Memory column store with compression, SIMD processing, temperature‑based replacement, and big‑table cache—detailing their parameters, operation, and monitoring methods for improved database performance.