Oracle Insights: Tales of the Oak Table

Oracle Insights: Tales of the Oak table eleven world-renowned industry experts proffering their own point of view very experienced, entry, and insights on Oracle where he was, wherever he goes, how (and how not) to use successfully, the software and techniques they have put in place to help people achieve their objectives, and some frightening tales of what can happen when the fundamental design principles are ignored.

The co-authors have solved many problems of the worst performance of Oracle in the world, and they have saved at least one each sentenced flagship project. For many years, they have been sharing their unique knowledge with each other at conferences around the OakTable, and in cafes, restaurants and bars on five continents. Now they want to share their key ideas with you.

A central feature of this book focuses on how you can avoid mistakes and debilitating during the construction of Oracle software projects. From these stories, you discover the simple steps to help you avoid real pain on your next (or current) Oracle project.

Since 1992, Oracle introduced a new way of extracting detailed information on response time of a database: SQL extended the mechanism trace. In 1995, I began to learn much more about this feature when my colleagues at Oracle Corporation, used to eliminate the guesswork Oracle performance improvement projects. The magic of this new extended SQL trace feature is that it has led analysts to predict the exact response time impact of a change in the proposed system. At the time, this predictive capability was revolutionary. The predictability and the concept of "fully informed decision" was the basis of my career since then.

In 1999, I left the company Oracle to work full time creating a new method for improving the performance I was hoping that exceed by far the reliability and accuracy of traditional methods of Oracle. In our book, Oracle Performance Optimization (Millsap and Holt, O'Reilly & Associates, 2003), Jeff Holt and myself have published the full technical details of our new method and extent SQL trace tool itself. Here, I describe the story behind Oracle SQL extended capacity to trace its history, the people who contributed to the development, and how and why you might consider using it.

Download Oracle Insights: Tales of the Oak Table