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 is meant by stacked list?
Explain the way(s) you find an exit(s) to a given standard sap program?
how to creat a table with out primary key
what is set cursor and get cursor command in module pool
What are the tables using in diff modules like SD, PM, MM, QM AND FICO? give me some example names ? Do we need to use the existing tables in R/3 most of the time?
What are the types of records that are transferred to sap r/3 and used by interfaces? : abap bdc
What are the aggregate objects in the dictionary? : abap data dictionary
what are the similarities between internal tables and structures?
What is the use of f4if_shlp_exit_example function module ? : sap abap data dictionary
What are the disadvantages of abap query tool?
Explain how to create any functions? How to go about it?
A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain?