Database Reference
In-Depth Information
Starting SQL Trace
The following procedure can be used to start a SQL trace for a program that is causing per-
formance issues in the system:
1. Call transaction code ST05. Select either Activate Trace or Activate Trace With Filter.
The Activate Trace option will start a SQL trace for the user who started the transac-
tion. Activate Trace With Filter will provide different filtering options for capturing
theSQLtrace.
Figure22-2
providesthefilteringoptionsavailableforactivatingaSQL
trace. Choose the user account under which the problem SQL is running and start the
trace by clicking the green check mark.
