AWR
From Oracle FAQ
(Redirected from Awr)
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
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
AWR was first introduced with Oracle 10g.
Licensing
Only users that licensed Oracle Enterprise Manager Diagnostic Pack are entitled to use AWR. Other users should continue to use Statspack.
Change snapshot settings
BEGIN
DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(
retention => 43200,
interval => 10);
END;
/
SELECT * FROM dba_hist_wr_control;
Also see
- ADDM - Automatic Database Diagnostic Monitor
- Statspack - tool for taking and comparing database performance snapshots
External links
- 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 | # |
