ITPUB
ITPUB
Sep 30, 2016 · Databases

Master Oracle Memory Tuning: Key SGA & PGA Parameters Explained

This guide walks through Oracle's memory architecture, explains SGA and PGA components, details essential memory parameters with recommended values, and provides step‑by‑step SQL checks to diagnose and tune performance on both 32‑bit and 64‑bit systems.

Database PerformanceMemory TuningOracle
0 likes · 14 min read
Master Oracle Memory Tuning: Key SGA & PGA Parameters Explained
dbaplus Community
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.

12cDatabase PerformanceIn-Memory
0 likes · 13 min read
Oracle 12c Memory Innovations: Smart Flash Cache, PGA Limits & In‑Memory Column Store