AWR

From Oracle FAQ
Jump to: navigation, search

AWR (Automatic Workload Repository) is a built-in repository (in the SYSAUX tablespace) that exists in every Oracle Database. At regular intervals, the Oracle Database makes a snapshot of all of its vital statistics and workload information and stores them in the AWR.

History[edit]

AWR was first introduced with Oracle 10g.

Licensing[edit]

Only users that licensed Oracle Enterprise Manager Diagnostic Pack are entitled to use AWR. Other users should continue to use Statspack.

Change snapshot settings[edit]

BEGIN
  DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(
        retention => 43200,
        interval  => 10);
END;
/
SELECT * FROM dba_hist_wr_control;

Also see[edit]

  • ADDM - Automatic Database Diagnostic Monitor
  • Statspack - tool for taking and comparing database performance snapshots

External links[edit]

  • spViewer Tools - tools for AWR and STATSPACK performance data analysis and tuning
  • Performance Explorer-i - tool for automated Oracle AWR and statspack performance spikes root cause analysis


Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #