What is SQL Trace, how would you carried out performance
analysis of ABAP code using SQL Trace? Give the steps?
Answers were Sorted based on User's Feedback
Answer / renuka
SQT Trace is used to analize the performance of select
queries.Transaction code is ST05.
STEPS:
go to ST05
selet Active mode
select Trace on
select application provide the transaction code in command
line like xk01,xd01 like that
now enter the data in application
again go for ST05
select Inacivemode
Trace off
List Trace
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
What are the things you did in ALV grid display?
Can we use instance attributes inside a static attributes? say yes or no ?
1 Answers Accenture, Cognizant,
Explain the advantages and disadvantages of different types of bdc's?
please any one can tell me How to validate the data in Table maintinance generator?how can u validate the table field values if u r entering the data into fields .it shows record is wrong?wher we can done validation in table maitenance generator before getting the data as out ?
What is direct input method?
Type groups?
what is check table..what is domain?
What is the difference between the exits created in M.M and S&D?
How do you send the output of a script as an email attachment
What does import and export do?
What is the difference between internal tables and extract datasets? : abap modularization
How will you transfer data into a file in application server?