This article walks through the internal structures of MySQL, Oracle, and PostgreSQL, detailing their logical and storage layers, key modules, process interactions, memory components, and how these elements cooperate to handle client requests and ensure data integrity.
This article explains Oracle's architecture—including the SGA, Shared Pool, Data Buffer, and Log Buffer—shows how each component influences SQL parsing, bind variables, result caching, direct‑path inserts, batch commits and logging, and provides step‑by‑step experiments and practical techniques for diagnosing and tuning performance bottlenecks.
This guide presents comprehensive Oracle database performance optimization techniques—including data structure design, application architecture, SQL tuning, memory and CPU adjustments, I/O balancing, and essential tools—providing actionable steps and example queries for DBAs to improve system responsiveness and efficiency.
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.
This article compiles a comprehensive set of Oracle SQL queries that monitor wait events, rollback segment contention, tablespace and file system I/O ratios, SGA hit rates, dictionary cache efficiency, MTS activity, fragmentation, and other critical performance metrics, often with recommended threshold values.
The article explains Oracle's database architecture, detailing how the server comprises an instance and a database, the structure and functions of the SGA memory components, and the roles of key background processes such as PMON, SMON, DBWn, LGWR, CKPT, and ARCn.
This article explains Oracle's database architecture, detailing the division between instance and database, the structure of SGA memory, and the roles of key background processes that together enable user interactions and ensure data consistency and recovery.
This comprehensive guide explains Oracle's memory‑management evolution, compares manual SGA/PGA sizing with ASMM, AMM and PGA automatic management, details key parameters and hidden settings, shows how to size SGA, PGA and large pages, and offers practical best‑practice recommendations for DBAs.
This article provides a comprehensive overview of Oracle Database architecture, detailing the server components, instance memory structures such as SGA, essential background processes, and the physical and logical storage layers, helping readers understand how Oracle organizes data and manages operations.
