Something is wrong with how Oracle tracks I/O statistics in AWR – here's the reproducible anomaly, the evidence it's real and the investigation into what causes it.
Tag: AWR reports
Oracle AWR Reports: When Averages Lie
An ERP database showing intermittent slowdowns looked fine in AWR – because AWR averages hide latency spikes. Here's why averages mislead and what to look at instead.
New AWR Report Format: Oracle 11.2.0.4 and 12c
Oracle quietly changed the AWR report format in 11.2.0.4 and 12c – here's what moved, what's new and what DBAs relying on the old layout need to know.
Oracle AWR Reports: Understanding I/O Statistics
Oracle AWR reports contain multiple I/O sections that measure subtly different things – here's what each one actually captures and why conflating them leads to the wrong conclusions.
AWR Generator
A script that automates the generation of multiple consecutive Oracle AWR reports – useful for profiling database performance across time without manual intervention.
flashdba 