CHAPTER 01 · Foundation
🏗
Oracle Architecture for Performance Tuners
The mental model every tuner must have. Instance vs database, SGA/PGA layout, background processes, and the full lifecycle of a query from parse to fetch.
SGA / PGA
Buffer Cache
Shared Pool
LGWR / DBWR
V$ Views
CHAPTER 02 · Core Diagnostic Framework
⏱
Wait Events & the Oracle Performance Model
The chapter that separates average DBAs from great tuners. Time-based performance model, all 12 wait classes, the idle filter rule, and the 3AM emergency toolkit.
ASH Queries
Wait Classes
Idle Filter
Blocking Sessions
3AM Toolkit
CHAPTER 03 · Core SQL Engine
🧠
SQL Execution & the Oracle Optimizer
Every performance problem traces here. Parse/Bind/Execute/Fetch phases, CBO statistics, reading execution plans with E-Rows vs A-Rows, join methods, and bind peeking.
Execution Plans
CBO Statistics
Bind Peeking
Join Methods
SQL Baselines
CHAPTER 04 · Access Path Mastery
📇
Indexing Deep Dive
B-tree internals, clustering factor, composite column ordering, covering indexes, and the 8 conditions that silently kill your index. The invisible index testing technique.
B-tree Internals
Clustering Factor
Composite Order
8 Killer Conditions
Invisible Index
CHAPTER 05 · Memory Architecture
💾
Memory Tuning: SGA & PGA
Buffer cache advisor, shared pool fragmentation, ORA-04031 diagnosis, PGA work area modes, sizing formulas, and why AMM + HugePages don't mix on Linux.
Buffer Cache Advisor
Shared Pool
PGA Work Areas
ASMM vs AMM
HugePages
CHAPTER 06 · Storage Layer
💿
I/O & Storage Tuning
I/O taxonomy, datafile and segment-level analysis, redo log sizing, temp tablespace design, checkpoint tuning, DBWR async I/O, partitioning for I/O elimination, and storage layout best practices.
Redo Log Tuning
Datafile Analysis
Partitioning
Checkpoint
Async I/O
CHAPTER 07 · Final Chapter
🔒
Locking, Concurrency & Contention
MVCC locking model, all enqueue types, blocking chain analysis, latch contention, deadlocks, the missing FK index trap, sequence contention, SKIP LOCKED queue processing, and the complete 3AM kill-the-blocker workflow.
MVCC Model
Enqueues
Deadlocks
FK Index Trap
SKIP LOCKED