Dynamic Oracle Performance Analytics: Using Normalized Metrics to Improve Database Speed

© Roger Cornejo 2018

Roger CornejoDynamic Oracle Performance Analyticshttps://doi.org/10.1007/978-1-4842-4137-0_2

2. Gathering Problem Information

Roger Cornejo¹ 

(1)

Durham, NC, USA

 

Before I begin Chapter 2, let me introduce Part II of this book, which is made up of Chapters 2–7.

When I began tuning Oracle databases and applications back in the mid-1980s, I was using the methods that were state of the practice at that time and then moved to the traditional methods and tools mentioned in Chapter 1 as they became available. For metrics-based analysis, I looked at data in individual tables/views—first in the v$ views, later the StatsPack views when they were introduced, and finally, beginning with version 10g, I considered metrics persisted in the AWR ...