Difference between revisions of "Oracle AWR"

From Dirty Cache Wiki
Jump to navigation Jump to search
(Created page with "{{stub}}")
 
 
Line 1: Line 1:
{{stub}}
[[Category:FAQ]]
 
= 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 [https://oracle-base.com/articles/10g/automatic-workload-repository-10g Oracle Base - AWR] for more details on how to use it.

Latest revision as of 14:47, 25 August 2021


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.