how to find if there are an expensive sql statements
running.if yes,what to do?

Answer Posted / lalit rana

You can check your Early Watch report which gives you the
list of expensive SQL statements and then you can
coordinate with you ABAP consultants to get it fine tuned.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you solve oracle archive struck?

1466


How can you view locked transactions?

630


How to check cpu usage in EP?

1486


hi friends, in sap screen with 000 client i unable to logon,with 001 client i can login but i want to log on with 000 client how i can loggin with 000 client intial screen ,please can u help me

6090


what is the procedure for java stack upgradation?

1890






Explain transport domain?

549


Explain kernel upgrade?

623


What is transport domain?

1414


1)Have you used performance tuning? What major steps will you use for these? 2)In production what is the user exit? 3)What type of user exits have you written? 4)Difference between Search Helps and Match Codes 5)On which even we can validate the input fields in module progams? 6)what are the table controls in BDC ? 7)what is the difference between bdc and lsmw ? 8) If the scripts are client dependent, what above driver program ? (client dependent / independent) 9). I have two pages, In one page I want address, Header, Main & footer. In the second page I want only Main. How to do it? 10) Will 50,000 records be uploaded directly into APP's Server? 11) What is the button to change the variant in ALV ? 12) If your project is support project ? when is your implementation has completed ? 13)In start of selection, if we perform validation, what happens ? 12)How to join 3 tallies & looping. We have developed a program in a client say (200- client) and 210 has test data. No developing rights. How to test data? 13)How to transfer data which is coming from are report as output to another report 14)How to create standard text and how do u transfer it ? 15)What are the views when we are creating Material ?

1956


Hi i am Ramesh want to know that which course in sap is most suitable for my younger brother who has BSC qualification and is this course is job oriented

1623


Explain what is business kpis ?

635


What is the difference between Party & Service without party in XI (ID)?

1888


how to do system refresh?not the client copy but the-standard-system-refresh.

1628


What is your organization’s security philosophy? What level of security does your data require? How much risk are you willing to assume in each application area?

1500


How you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?

785