SQL Detail Section
This section shows the report and trace detail portions for each SQL statement type.
Field descriptions are shown in Field Descriptions of SQL Activity Detail Report and Trace Details.
DDF information is included in all SQL Activity summaries, when present.
When an SQL statement type is not recognized, other is printed.
The report and details blocks are divided into columns. The column labels vary for report and trace and for the summarization used. The following column labels are used:
- NL
- Nesting level of stored procedures, triggers and user-defined functions. This is valid for trace only. Values are summarized by occurrence.
- EVENT
- The event being reported or traced, such as the cursor name in a summary by cursor or the program name in a summary by program.
- COUNT
- The number of occurrences of this event.
- TIMESTAMP
- The timestamp of the event begin.
- TOT.ELAPS
- The total elapsed time of the event, that is the elapsed time for all statements within the event.
- AET/EVENT
- The average elapsed time of the event.
- TOTAL TCB
- The total TCB time of the event, that is the TCB time for all statements within the event.
- TCB/EVENT
- The average TCB time of the event.
- ELAP.TIME
- The elapsed time of the event.
- TCB TIME
- The TCB time of the event.