Foreword from the First Edition
I started using the Oracle RDBMS a little over 20 years ago, and it took about three years for me to discover that troubleshooting and tuning had acquired a reputation verging on the mystical.
One of the developers had passed a query to the DBA group because it wasn’t performing well. I checked the execution plan, checked the data patterns, and pointed out that most of the work could be eliminated by adding an index to one of the tables. The developer’s response was: “But it doesn’t need an index, it’s a small table.” (This was in the days of 6.0.36, by the way, when the definition of a “short” table was “no more than four blocks long”). So I created the index anyway, and the query ran about 30 times faster—and ...
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.
