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

Customizing the AWR

The AWR and its collections can be customized to some extent. You can customize AWR in the following areas:

  • Change the period between collections (also known as snapshots), even to the extent of switching off collection.

  • Change the period of retention of data.

  • Create on-demand snapshots.

  • Create baselines for comparison.

With the exception of the last bullet point, you will see how these can be done in this chapter. Before you customize the AWR however, you need to understand the dependencies.

AWR Dependencies

Most of the downstream self-managing, proactive, reporting features of Oracle Database 10g depend on the AWR data collected periodically. You need to keep this in mind if you reduce or change the AWR collection and storage ...

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