AWR: Your Guide on What to Do Next

  • Stelios Charalambides


In the dim and distant past there used to be a utility called Statspack {XE “Statspack”}. More people now use AWR than Statspack, but Statspack is still useful for those sites where there is no Enterprise edition and for which there is no Diagnostic pack. It also works the same as it did back in 7.3.4. Statspack was replaced long ago by the more sophisticated tool AWR (Automatic Workload Repository). Has AWR now been replaced by SQLT? No. They are different blades on the same Utility toolkit that you always carry with you as a DBA. One for tuning SQL and one for tuning the system. Let me explain what I mean by that last statement.


Golden Rule General Report Difference Report Tuning Problem Hide Parameter 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Stelios Charalambides  2017

Authors and Affiliations

  • Stelios Charalambides
    • 1
  1. 1.New HamptonUSA

Personalised recommendations