AWR

From Oracle FAQ

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.

Contents 1 History 2 Licensing 3 Change snapshot settings 4 Also see

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

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	#