Summarizing Trace Lists 

For further performance analysis, the following functions are available:

·        Summarize trace by SQL statements

·        Identical selects

·        Summarized table accesses

These functions provide an overview of accesses and, in the case of the function Summarized Table Accesses, table buffer accesses.

 

Procedure

To access the summarized lists from the trace list, the detailed trace list, or the time-sorted list, choose Trace List à Summarization Function (summarize trace by SQL statements, display identical selects, Summarized table accesses).

You can use the F1 help to obtain information about the column contents of the individual lists.

 

Results

Function Summarize Trace by SQL Statements

The following columns are displayed in this list:

·        Executions: Total number of executions of the statement.

·        Identical: Percentage of "value-identical" select statements of the "statement-identical" select statements.

·        Duration: Total execution duration for all "statement-identical" SQL statements in microseconds. For the individual statements, the total is made up via the operations prepare, open, or reopen, fetch, close.

·        Records: Total number of rows (records) returned to the ABAP program(s) for these "statement-identical" SQL statements.

·        Time/exec: Average execution time of one of the executed statements in microseconds.

·        Rec/exec: Average number of rows (records) processed in the execution of a statement.

·        Avg. Time/r: Average processing time (in microseconds) required for a row (record).

·        Min. Time/r: Minimum processing time (in microseconds) required for a row (record).

·        Length: Length of the row (record) of a table.

·        Btype: Characteristic for the table buffer (see also F1 help)

·        Tabtype: Table type

·        Object Name: Name of the table

·        SQL Statement: SQL statement

On this summarized list, a number of functions are available for further analysis; you will already be familiar with these functions (such as Explain, Dictionary Information, Display Call Positions in ABAP Program) from the initial trace lists.

 

Identical Selects function

For identical selects, the following columns are displayed:

·        Executions: Number of calls of a select statement with the specified where clause.

·        Object Name: Table name

·         Where Clause: The where clause of the SQL statement. If the clause ends with the character string ‘...’, it was truncated.

 

Function Summarized Table Accesses

This summarized list provides the following information for the SQL and the buffer trace:

·        Work Proc. No.: ID (see transaction sm50, for example) of the process by which the trace records were written.

·        Ptype: Work process type (see also F1 help)

·        Client: Client in which the user was working and in which the trace records were written.

·        hh:mm:ss.ms. Time at which the logical trace record was created. Displayed in the format hours:minutes:seconds.milliseconds

·        Transaction: Name of the transaction or program from which the specified table was accessed.

·        Table Name: Name of the table that was accessed within the specified transaction or program.

·        Statement: Name of the statement executed on the specified table.

·        Total Records. Total number of read, deleted, or updated records, depending on the statement executed.

·        Total Access Time: Total time required for executing the statements on the table. Displayed in the format milliseconds.microseconds.

·        DB Connection: Logical name of a database connection.

 

For further analysis of this summarized list, a range of functions is available such as sorting by column, selecting rows or parts of rows with subsequent summarization.