Extended SQL Trace Data
Cary V. Millsap · Apress eBooks · 2004
Way back in 1992 , Oracle introduced a new means of extracting detailed response time information from a database: the extended SQL trace mechanism. In 1995, I began to learn much more about this feature when my colleagues at Oracle Corporation used it to remove the guesswork from Oracle performance improvement projects. The magic of this new extended SQL trace feature was that it allowed analysts to predict the exact response time impact of a proposed system change. At the time, this predictive ability was revolutionary. Predictability and the resulting notion of “fully informed decision making” has been the foundation of my career ever since. 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.