·
9 min read
MongoDB Slow Queries: How to Find and Fix Them
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.
#tuning
Articles tagged tuning. View all articles
·
14 min read
How to Analyze an Oracle AWR Report: A Step-by-Step Guide
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.
·
11 min read
What is Oracle AWR: Complete Guide to the Automatic Workload Repository
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.
·
11 min read
How to Generate an Oracle AWR Report
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.
·
15 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, diagnostic SQL queries for each, and step-by-step fixes.