AWR

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	#