It is also very encouraging that as result of the additional index, the top two logical IO statements consumed a combined 12.5M logical IOs (Figure 9-34), whereas before the index addition, the top two consumed 32.9M logical IOs (Figure 9-29). So, by aligning our ORTA with the application analysis, we correctly targeted the high-impact SQL statements.

The beauty of this is the drop in logical IO consumption occurred in conjunction with an increase in the number of SQL statement executions. For example, Figure 9-30 shows Oracle processed 134M logical IOs and 48.7K SQL statement executions. But with the additional index, Figure 9-35 shows Oracle processed only 37M logical IOs while executing over 53.1K SQL statements! And this all occurred with a reduced CPU utilization.

Figure 9-35. Shown is the workload diagnostic information. Compared to Figure 9-30, logical IO response time was maintained, Oracle processed fewer logical blocks from 74.7 lio/ms to 20.5 lio/ms, while increasing the SQL execution rate from 27.1 exec/sec up to 29.5 exec/sec!