Object Statistics and Deployment
Tony Hasler · Apress eBooks · 2014
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. 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.