Oracle AWR

From Dirty Cache Wiki
Revision as of 14:47, 25 August 2021 by Bart (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.