CHAPTER 6
Object Statistics and Deployment
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 ...
Get Expert Oracle SQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
