Easily monitor Oracle disk I/O latency

Oracle 10g v$ views and the AWR tables have some great ways to measure average I/O durations, and you can use v$event_histogram view and the dba_hist_system_event table to plot the distribution of physical disk read speed.

Plotting I/O speed with v$event_histogram

The v$event_histogram view displays a histogram of the number of waits, the maximum wait, and total wait time on a wait event basis. Using this view, a histogram showing the frequency of wait events for a range of durations can be created. This information assists in the determination of whether a wait event is a frequent problem that needs addressing or a unique event.

Read my notes here and see the scripts for measuring disk I/O speed for your Oracle database:


For complete details, see my book "Oracle Tuning: The Definitive Reference":



Is your Database Healthy?

Oracle is the worlds most complex and robust database and there are hundreds of sub-optimal setting that can cripple your database performance.

BC has a great Oracle health check where we identify all database bottlenecks to ensure that your mission-critical system is running at optimal speeds.

Just call 800-766-1884 to schedule your health check.


Need Oracle Training?

The very best Oracle training comes from Burleson Consulting, where you get an on-site visit by an experienced Oracle expert and author.  Whether it's one-on-one mentoring or getting a customized on-site Oracle training class, there is no substitute for BC Oracle training.  Just call me at 800-766-1884 for details, and check-out our on-site Oracle training catalog: