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.


Shipping Cond Adapter Bove 
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.


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