Database Optimization: Measuring Oracle disk I/O speed

March 1, 2004

[From Builder.com]

Because all Oracle databases retrieve and store data, the relative cost of physical disk access is an important topic. In Oracle, we see two types of data block access:

  • db file sequential read-A single-block read (i.e., index fetch by ROWID)
  • db file scattered read-A multiblock read (a full-table scan, OPQ, sorting)

Physical disk speed is an important factor in weighing these costs. Faster disk access speeds can reduce the costs of a full-table scan vs. single block reads to a negligible level.

For example, the new solid state disks provide up to 100,000 I/Os per second, six times faster than traditional disk devices. In a solid-state disk environment, disk I/O is much faster and multiblock reads become far cheaper than with traditional disks.

The article continues at http://builder.com.com/5100-6388_14-5159055.html