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