Hierarchy
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-TWB-TST-P-PA (Application Component) Performance Analysis (Transaction ST05)⤷
SQLT (Package) Trace for SQL, Enqueue, RFC, Memory
Basic Data
| Data Element | SQLTDURA |
| Short Description | Execution time of an SQL statement |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | CHAR9 | |
| Data Type | CHAR | Character String |
| Length | 9 | |
| Decimal Places | 0 | |
| Output Length | 9 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 4 | Time |
| Medium | 8 | Duration |
| Long | 18 | Minimum duration |
| Heading | 8 | Duration |
Documentation
Definition
The duration (execution time) of a statement is displayed in microseconds.
The execution time is displayed in the usual decimal format chosen by the user. If the size of the output area is not sufficient to display the time, this is indicated by the display of "*" and a sequence of digits.
The execution time is measured including the necessary transfer time. For example, from the application server to the database server and back.
Note that for the SINIX operating system, the interval is 10 000 microseconds. If the execution time is less than 10 000 microseconds, the duration appears as zero in the trace list.
For an enqueue trace, the duration is the sum of the remote time and the request time. The sum may be inaccurate as the two times are measured differently.
For a table buffer trace, a series of Fetch statements is normally compressed. In this case, the column "Duration" contains the execution time for all of the merged Fetch statements. You can recognize the Fetch statements using the "Statement" column. The total number of Fetches and the average duration of a Fetch statement (in seconds) are displayed in this column.
History
| Last changed by/on | SAP | 20010205 |
| SAP Release Created in |
