Use Tcode DBACOCKPIT (ST04) to find SQL statemnts, sort via the avg elasp

How are expensive SQL select statements recognized?

Question Posted / shanker

Answer Posted / shanker

Use Tcode DBACOCKPIT (ST04) to find SQL statemnts, sort via
the avg elasp time to get expensive SQL statement.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between developer trace, system log and system trace?

1200

you want to do a system-copy. List the steps you will take.

933

steps to congigure CMS in XI ?

2239

Screenshot document for solution manager installation.

1747

What is JVM switch. Why JVM switch is required ?

2547

How can I restrict the user from printing?

1047

Can you change the profile parameter in the os level? Which one is advisable why?

1203

What do you understand by transport management in sap basis?

1041

Explain how client refresh is different than client copy?

1168

you want to take sap backup using brtools. How would you do that?

1111

What is the folder it will ask to install oracle?

1142

What are common transport errors and their codes?

1957

list some common errors faced with jspm while updating java stcks.and solutions.

2565

How do you generate (recover) old system logs in a newly created SLOG00?

2133

Can you tell me installation procedure of SAP on UNIX

2338