Robin Moffatt • 9/14/2010

The danger of averages - Measuring I/O throughput

This technical article discusses the pitfalls of using average I/O throughput metrics (like those from Oracle AWR snapshots) for system capacity planning. It demonstrates with real query outputs and minute-by-minute data from V$SYSMETRIC_HISTORY how averages mask significant short-term spikes (e.g., over 400 MB/s), arguing that peak usage, not averages, is critical for accurate infrastructure sizing.

0 comments

#oracle #metrics #Database Performance