Automatic Workload Repository Baselines

In Oracle Database 11g, Automatic Workload Repository (AWR) baselines provide powerful capabilities for defining dynamic and future baselines, and considerably simplify the process of creating and managing performance data for comparison purposes.

Oracle Database 11g has, by default, a system-defined moving window baseline that corresponds to all of the AWR data within the AWR retention period. There can only be one moving window baseline.

Oracle Database 11g provides the ability to collect two kinds of baselines: static baselines  and moving window.

Static baselines can be either single or repeating. A single AWR baseline is collected over a single time period. A repeating baseline is collected over a repeating time period (for example, every Monday in June).

In Oracle Database 11g, baselines are enabled by default if STATISTICS_LEVEL=TYPICAL or ALL.