PART IV
Optimization
Engineering isn’t about perfect solutions; it’s about doing the best you can with limited resources.
— Randy Pausch, The Last Lecture. 2008.
Only once you have identified the root cause of a performance problem should you try to solve it. Regardless of the problem you are facing, the essential goal to achieve is reducing—or, even better, eliminating—the time spent by the most time-consuming operation. Note that a single operation may be composed of many actions that are executed one by one. For example, many fetches are necessary in order to fully process a query returning many rows.
Chapter 11 describes the available SQL ...
Get Troubleshooting Oracle Performance, Second Edition 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.
