Practical guides on Oracle & PostgreSQL performance, AWR/ASH analysis and database diagnostics.
What an AWR analyzer is, why reading AWR reports by hand is slow, how to interpret the key sections and common patterns, and how to get a root-cause diagnosis in seconds — no database connection required.
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 guide to diagnosing MongoDB performance problems using serverStatus, mongostat, mongotop, currentOp and other built-in tools — with diagnostic queries and fix recommendations.
Step-by-step guide to finding MongoDB slow queries using the profiler and explain plans, understanding COLLSCAN vs IXSCAN, and fixing performance with the right indexes.
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.
A practical guide to pg_stat_statements: what it is, how to install it, the columns that matter, and example queries to find your slowest SQL.