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

2. Gathering Problem Information

Roger Cornejo1 
(1)
Durham, NC, USA
 

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

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 ...

Get Dynamic Oracle Performance Analytics: Using Normalized Metrics to Improve Database Speed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.