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


Please Help Members By Posting Answers For Below Questions

Search help exit details.

919


Do you know any other patterns if yes.. explain

867


can anyone please tell me, in orient paper mill project which fields exits for creating report.

1266


Name a few data dictionary objects? : abap data dictionary

674


Name some system global variables you can use in abap programs?

544






what are the problem we face during development( if we say v are in support(development)? what are the critical problems araises during LSMW updation and Smart form layout development for involce and po? very very important questions now a days commonly asking..plz plz reply me

1536


What is an abap dictionary? : abap data dictionary

588


How do you get the number of lines in an internal table?

614


Is it possible to pass data to and from include programs explicitly? : abap modularization

738


What are the differences between table controls and step loops?

550


Explain how many types of tables exist and what are they in data dictionary?

597


Can we call reports and transactions from interactive reporting lists?

618


What are the steps in a bdc session? : abap bdc

565


What are the function modules used to create batch input session? : abap bdc

621


What are internal tables? How to use a specific number occurs statement?

562