How are expensive SQL select statements recognized?
- 5 Answers
- 8735 Views
- IBM, I also Faced
- E-Mail Answers
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
Transport request types and its syntax?
What is client administration in sap system? Why do we use multiple clients in sap system?
what is your project architecture?
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?
How client refresh is different than client copy?
i am working with NBFC- MNC in personal loan dept. I applied for Internal Job Position in banking Division. My overall (10 years) experience in sales and People Management and in Internal Job Posting they require person for backend activity. There will be not repotees and its individual performance job. My Question is 1. If they will ask why you want to change your field form sales to backend job what should I answer? 2. The opening is in Chennai and since 10 year I am in Gujarat so if they ask why you want to change your home town location? Arpan Thakkar
What are saplpd and tcp/ip print server and purpose? And difference b/w saplpd and tcp/ip print server?
Is there any report or table in which user log off time is stored in sap?
Hi,My name is Saurabh I have done BMS & currently working in Wipro BPO (1 year). I want to pursue my career in SAP. As I am totally new in the IT field(no course & no experience) Please could you suggest whether to do a certification from Certified institutes or Non Certified institutes.What is the difference? Also, Is MBA necessary to do certification from Certified institutes?
how can i change access to a user who is having access for SPRO display only to change access in sPro
How to identify a particular T_Code has been modified or not? If yes, how to identify who modified particular T_Code in current system?
I have solman 7.1 Stack3. I want to upgrade to stack13. My question is can I directly download stack13 files from marketplace, if yes, will those files includes xml file ? (MOPZ is not configured in my system).
TMS Configuration?
For ex: i scheduled one ABAP program as a background job but it was running 10 days, how to analyze the problem?
list some common errors faced with jspm while updating java stcks.and solutions.
