Oracle AWR: Difference between revisions

From Dirty Cache Wiki
Jump to navigation Jump to search
Created page with "{{stub}}"
 
No edit summary
 
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.