1. Categories >> Software >> ERP CRM >> SAP >> SAP Basis
  2. Suggest New Category

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sap single stack system?

668

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

1699

Hi I am new in this forum and in this practice. can anyone help me out in finding out how to get training material for SAP CRM 2007.

1769

I need to change the Company address parameters of a user. The path is SU01 -> -> Change - > Address Tab - > Display Icon in Company Address section. In the new screen, i see a preview section icon; on clicking which, I can change the parameters such as "Sending Country"; "Street/PO Box number" and number of lines in the resulting pop up. Here though i change the parameter "Street/PO Box number" field to 'S' ( Street has priority over PO Box), its changing again to 'P' (PO Box has priority over street) only. In the help section it is written that if we set the user parameter (tcode SU3) LND1 to the desired country we can control the user specific Sending Country with the desired value else it takes the Sending Country of the Company defined by default. But no such parameter has been given for Street/PO Box number so that we could change its value atleast there. Someone suggest me how to change the Street/PO Box number of the Address format for a user to the desired value.

4418

Explain deletion flag. Where is it used in archiving process?

595




What is the role of “ application server” ?

645

Can you tell me about the landscape migration to cloud ?

1233

how can we set a/r a/p netting for inter company code transactions? is it possible to do? if yes, give the solution?

2004

How to transfer request which is created directly on quality server & has to be moved to in production server?

1131

What is R/3? and what is basis version?

715

Explain what is business kpis ?

639

What are the activities you done in PI?

2585

What are the Pre- requisite for system copy?

1373

Is there a way to perform sapgui 640 roll out using a centralized server?

611

TMS Configuration?

1453