O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11. Effectively Using the Automatic Workload Repository

IN THIS CHAPTER

Introducing the AWR

Customizing the AWR

Performing Baselining

Active Session History

New Features in Oracle Database 10g Release 2

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required