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 BDCDATA structure?
What is at exit-command:?
What you did in BDC?
6 Answers Accenture, FutureSoft,
Describe ALV Report
Which is the event trigger last?
what is the difference between a table and template in Smartforms?
4 Answers HCL, Tech Mahindra, Wipro,
What is transparent table?
what is a field symbol?
What is ITS? What are the merits of ITS?
what is the main main difference between data element and domain? (i know definitions,i don't want definations).
1.search help is there for table or structure or both? 2.in structure there is no technical attribute, then how will u call data elements/fields into the structure? 3. i want to add/write some code in sap standard program in function module related in badi,then how will u write your code in sap standard Fm in badi? 4.what is kapler badi? 5.what is the use of log text in table technical attributes while creating table? 6.what are the fields i have to take to releae/creat a PO from Pur req? 7. if i have already release po as per the Pur req and vendor supplied the material,then again i want same 100 material,then wt will u do? are u release po again? what are steps u follow for this situation?
what are the sap financial periods
4 Answers i Spy Technologies, MD Synergy,