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

8. Case Studies

Roger Cornejo1 
Durham, NC, USA

In the previous chapter, I provided a framework for making the many decisions necessary when implementing the DOPA process. The discussion focused upon how you would choose to run the analysis, the various parameters, and views you would choose. In this chapter, I’ll lead you through several real examples.

The case studies presented in this chapter show the DOPA process in action. They detail the analysis of historic AWR metrics and the identification of root cause(s) of real reported Oracle database performance problems. These represent just a sampling of the kinds of problems encountered ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.