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.
AWR was first introduced with Oracle 10g.
Change snapshot settings
BEGIN DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS( retention => 43200, interval => 10); END; /
SELECT * FROM dba_hist_wr_control;
- ADDM - Automatic Database Diagnostic Monitor
- Statspack - tool for taking and comparing database performance snapshots
- 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|