This article walks through using ADDM to pinpoint problematic SQL statements in Oracle, creating and executing a SQL Tuning Advisor task, evaluating profile and index recommendations, and applying parallel execution to dramatically improve performance and resource usage.
This guide walks through upgrading an Oracle database to 19c, comparing pre‑ and post‑upgrade performance with HammerDB and AWR snapshots, using SQL Performance Analyzer and SQL Plan Management to evaluate SQL tuning sets, applying SQL Tuning Advisor recommendations, and finally automating the upgrade with the AutoUpgrade tool and post‑upgrade compatibility adjustments.
This article explains how Oracle wait events, especially latch contention such as cache buffers chains and LRU chain latches, reveal performance bottlenecks, and provides step‑by‑step methods, diagnostic tools, SQL examples, and tuning recommendations to locate and resolve database hotspots.
