ST03N to see the programs having expensive SQL statements SM50 to see whic

How to find expensive SQL statement, if found, what should
be done?

Question Posted / pwp

3 Answers
12303 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / pwp

ST03N to see the programs having expensive SQL statements
SM50 to see which table is acessing the program
ST04 to see the exact SQL statement and details
STAD/STAT to see more details

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is there a difference between user ddic and sap_all/sap_new?

1559

Have you done any up gradations?

2191

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

1064

What are the daily transactions?

1058

Is system user sap basis consultant and dialogue user other user like fico, hr, mm user?

1473

Mention what is the difference between central instance & application server?

1053

How to make security authorization reports?

2058

What is the purpose of webdisptcher and Installing and configuring Web Dispatcher what are the prerequisites?

2452

what is role of sap administrator in pi & ep?

2078

At os level how you can change the number of work process? How you can analyze the status of work process at os level?

1011

Explain domain controller?

1102

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.

4989

If a background job runs more than the time it should be completed normally then what actions will u take?

1759

How to find users used transaction codes which are not authorized for?

2342

What is the difference between central instance & application server?

1047