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!

If you have been reading this book sequentially, my hope is you easily followed the preceding performance analysis cycles. In a way, it is a broad review of the key aspects of this book. Each cycle involved conducting an OraPub 3-circle analysis, understanding Oracle internals, performing an ORTA, and anticipating the solution's impact. The following are the key points: