Articles tagged oracle. View all articles
Upload your Oracle AWR report and get a prioritized root-cause diagnosis in seconds — no more cross-referencing wait events, SQL and plans by hand. Free trial.
How to find and fix the worst SQL statements in Oracle using AWR Top SQL sections, v$sql, and ASH — with practical examples and tuning recommendations.
A practical guide to understanding the difference between Oracle AWR and ASH reports, when to use each one, and how to combine them for effective performance diagnosis.
A practical guide to reducing the most common Oracle wait events — db file sequential read, log file sync, buffer busy waits and more — with concrete tuning actions for each.
A practical step-by-step guide to reading and analyzing Oracle AWR reports: which sections to read first, what the numbers mean, how to identify root causes, and common patterns.
A complete guide to Oracle AWR (Automatic Workload Repository): what it is, how it works, what data it collects, how to use it for performance tuning, and its limitations.
Step-by-step guide to generating Oracle AWR reports in SQL*Plus: finding snapshots, choosing the right window, HTML vs text format, RAC environments, common errors, and how to read the output.
What Oracle wait events are, the 10 most common ones you'll see in AWR/ASH reports, diagnostic SQL queries for each, and step-by-step fixes.