What is SQL Trace, how would you carried out performance
analysis of ABAP code using SQL Trace? Give the steps?
Answer Posted / sumeet patil
Performing an SQL Trace:
Access transaction ST05. From the initial screen, click the check box for SQL trace, under the trace requests, click Trace on.
Run the program containing the SQL query that needs to be analyzed in the SE38 editor.
Come back to ST05 screen, under Trace requests, click Trace off.
Click List trace to view the trace of the current statement.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Difference between Read and Get cursor?
What is the first thing you do after vendor setup is complete?
What is the syntex used to call a screen as dialog box (pop up)?
Explain about interactive report?
Explain buffering concept usage?
When you prefer lsmw?
performance tuning concepts
How many main windows will be there in a page window?
Explain what are standard layouts sets in the sap script?
What are indexes? : abap hr
What are the commands used for interactive reports?
What is native sql?
if u take one worst program,in this program user write the logic is session method.in that program user can get some errors ,that errors we will see in call transaction method,how it is possible.?
Reports: Event functionality.
How to handle error in session method? : abap bdc