Extended SQL Trace Data
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.
KeywordsTrace Data Direct Memory Access Trace File Oracle Database Buffer Cache
Unable to display preview. Download preview PDF.