Extended SQL Trace File Format Reference

Abstract

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.