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

Introducing the AWR

The Automatic Workload Repository (AWR) is a new infrastructure component that is at the heart of the collection and processing of the vast amount of performance data in Oracle Database 10g. The data collected by AWR forms the basis for most of the problem-detection and self-tuning mechanisms that Oracle Database 10g provides. In fact, the performance-alert mechanisms rely on this data, as do many of the performance advisors. The Automatic Database Diagnostic Monitor (ADDM) uses this data as well, performing scheduled analysis of the data collected by AWR.

AWR consists of two components: in-memory performance statistics, accessible through V$ views, and snapshots of these V$ views “persisted” in the database that record the ...

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