Abstract
This chapter introduces the second of the two important themes of the book: how to manage the performance of SQL statements in a production environment. This is undoubtedly the most controversial chapter in this book as some experts may disagree with the views I express here, particularly as they fly in the face of Oracle's stated strategy. Nevertheless, I am very far from alone in reaching the conclusions that I have, and the techniques I describe have been used by a number of people to stabilize the performance of many Oracle databases. Let us begin with some generic observations about performance management.
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
© 2014 Tony Hasler
About this chapter
Cite this chapter
Hasler, T. (2014). Object Statistics and Deployment. In: Expert Oracle SQL. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-5978-7_6
Download citation
DOI: https://doi.org/10.1007/978-1-4302-5978-7_6
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-5977-0
Online ISBN: 978-1-4302-5978-7
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books