Oracle AWR

From Dirty Cache Wiki
Jump to navigation Jump to search

Automatic Workload Repository

Oracle Automatic Workload Repository (AWR) is an Oracle feature that allows users to generate detailed database performance reports. It requires a Diagnostics Pack license. An alternative is Statspack - which doesn't require a license and requires a DBA to set it up properly - and it produces less detailed, but still useful, text reports.

See Oracle Base - AWR for more details on how to use it.