Using the Oracle9i Release 2 and later formulas and based on the Statspack information shown in Figure 9-5, to determine the total IO read and write operations, we must sum the server process, database writer background process, and log writer background process IO read and write operations. The results are as follows:

The total of read and write IO operations over the 149.97-minute interval was 50,300. To get the standard IO operations per second (IOPS), simply divide the total IO operations by the reporting interval, remembering to convert to seconds.

When the IO administrator asks for Oracle's IO requirements, based on the Statspack report time period, you can confidently say Oracle's IO requirements were 5.59 IOPS. And if the IO administrator wants the breakdown by read and write operations, or even in megabytes per second, that can also be provided.