Oracle Disk I/O and Wait Events
Oracle I/O troubleshooting requires both database and operating-system evidence. A high request count can identify a busy workload, while high service time can identify latency; neither alone proves…
Practical database knowledge
Keep your databases running.
Oracle, SQL Server, backup, and recovery. Practical guides for diagnosing problems and getting your data back.
Featured series · 3 parts
Oracle SQL tuning with AWR & ASH
Follow the investigation from the first slowdown to a stable execution plan.
01 · AWR
Find and prove the regression
Identify the SQL, compare execution plans, and establish what changed.
02 · ASH
Find where the time went
Use ASH and runtime plans to understand waits and execution work.
03 · Plan stability
Tune and stabilize the plan
Evaluate advisor recommendations and stabilize a proven execution plan.