Figure 9-5. Based on the same data as Figures 9-1, 9-2, and 9-3, shown are Oracle IO-related consumption (requirements) metrics. This is an Oracle Database 10g Release 2 system, so all the metrics can be gathered from the Instance Statistics section (based on v$sysstat), and then used to calculate read and write IO requirements for the server processes and background processes in both megabytes per second (MB/s) and IO operations per second (IOPS).

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.