The SQL Activity Trace

This topic contains examples of SQL Activity traces and the commands used to generate them.

These traces are summarized at different levels. They can be summarized at the following levels:
  • All
  • Cursor
  • Occurrence
  • Program
  • Statement number
  • Statement type
Note: The trace also automatically includes a summary by thread and, if there is more than one thread per location, a summary by location. Each summary begins on a new page of the trace.