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 | SQLTTEXT20 |
| Short Description | Fields for restricting value range for SQL trace |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | TEXT20 | |
| Data Type | CHAR | Character String |
| Length | 20 | |
| Decimal Places | 0 | |
| Output Length | 20 | |
| 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 | Fld |
| Medium | 4 | Fld |
| Long | 14 | Field Label |
| Heading | 0 |
Documentation
Definition
For performance reasons it is advisable to assess only the useful part of the trace. You can limit the the type of trace (SQL trace, enqueue trace, RFC trace, and buffer trace), the users, the objects (tables for SQL trace, lock objects for enqueue trace), the operations (database operations for SQL trace, operations in the lock object for enqueue trace) and the execution time for the statements.
To specify the selection criteria for parameters
- User name,
- Object name and
- Operation,
you can use an exact description or a LIKE pattern and an option. To specify a LIKE pattern, as well as the usual character set you can use the meta character '*' for any character string and '_' for exactly one character. The system displays 'EQ' by default. You can select other options by choosing the 'Options' pushbutton. In doing so, you specify whether the trace records that meet the selection criteria are to be selected or excluded from the selection. The system displays 'Select' by default. If you click on the stoplights, the system displays the option 'Exclude from selection'.
If you choose 'Select', the operator is underlined in green or red.
For the duration you can specify a delimitation in microseconds. By default the system recommends that you select all trace records whose execution time is greater than the comparison value.
By choosing " =>...", you reach the next screen, where you can change the selection criteria as well as specify further criteria.
Initializing the Selection Parameters
The user name is already initialized with the name of the current user.
In the case of SQL traces, the object name is intialized so that the trace records relating to SAP system tables D010*, REPOLOAD, REPOSRC, REPOTEXT, DYNPSOURCE,DYNPLOAD, DYNPTXTLD, and DDLOG are excluded from the selection.
History
| Last changed by/on | SAP | 20010130 |
| SAP Release Created in |
