Extended SQL Trace File Format Reference

  • Norbert Debes


A SQL trace file contains a precise log of the SQL statements parsed and executed as well as the fetch calls made by a database client. This includes the CPU time and the elapsed (wall clock) time consumed by parse, execute, and fetch operations. Optionally, a SQL trace file includes information on wait events, which are indispensable for an accurate performance diagnosis. Last but not least, actual values for bind variables may also be included, e.g., when the PL/ SQL package DBMS_MONITOR is used to enable SQL trace.


Execution Plan Instance Service Trace File Bind Variable Buffer Cache 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Norbert Debes 2009

Authors and Affiliations

  • Norbert Debes

There are no affiliations available

Personalised recommendations