·
4 min read
How to Generate an Oracle AWR Report
A step-by-step guide to generating Oracle AWR reports in SQL*Plus: when to run them, which snapshots to pick, and HTML vs text format.
Blog
Practical guides on Oracle & PostgreSQL performance, AWR/ASH analysis and database diagnostics.
·
5 min read
Oracle Wait Events Explained: Top 10 and How to Fix Them
What Oracle wait events are, the 10 most common ones you'll see in AWR/ASH reports, and how to diagnose and fix each.
·
3 min read
What is pg_stat_statements and How to Use It
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.