Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2017 Stelios Charalambides
About this chapter
Cite this chapter
Charalambides, S. (2017). AWR: Your Guide on What to Do Next. In: Oracle SQL Tuning with Oracle SQLTXPLAIN. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-2436-6_2
Download citation
DOI: https://doi.org/10.1007/978-1-4842-2436-6_2
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-2435-9
Online ISBN: 978-1-4842-2436-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books