Chapter 11. Effectively Using the Automatic Workload Repository

IN THIS CHAPTER

Introducing the AWR 207

Customizing the AWR 215

Performing Baselining 220

Active Session History 222

New Features in Oracle Database 10g Release 2 236

In this chapter, we will see in greater detail two of the components that were introduced in Chapter 10, "Adopting a New Approach to Tuning"namely AWR and ASH. Both these components set the stage for the performance advisors that act on the data they collect. These performance advisors are detailed in the next two chapters, and you will need to understand the data that AWR and ASH collect in order to appreciate what the advisors do.