In summary, when running SQL scripts, be aware of the data used to derive the statistic. It may be less useful than you thought.

Oracle performance firefighting requires unique skills, tools, methods, deep technical Oracle internals knowledge, and a different perspective. Getting the most out of these areas requires an integrated framework. This chapter introduced the core supporting framework enabling spot-on diagnosis, multiple-perspective analysis, visual aids, and response-time analysis.

You may have noticed I frequently mentioned leaving out significant details and taking abstraction liberties. This was necessary to establish a solid framework without distracting you with details and side topics. The upcoming performance diagnosis chapters will provide ever-decreasing abstraction and a much deeper look into wait-event analysis and response-time analysis. Once the framework has been fully developed, the Oracle internals chapters will provide the technical underpinnings, allowing appropriate and relevant solutions to the correctly diagnosed problems. Once the framework and the internals are covered, we'll move into complete performance analysis integration in the final chapter.