How to find Expensive SQL Statements? How to solve?
Answer Posted / rout
U can find expensive SQL statements using T_code:ST05 /SM50
U can solve this either by killing the process or find out
the table that has been accessed adn creat some indexes ,so
that it can be accessed easily or get the workload
statestics information and tune the system.
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
How to do transport at OS level?
What are the different types of rfc?
At o.s level where to check for system logs of sap application?
Can you change the profile parameter in the os level? Which one is advisable why?
Hello Guys, If any body looking for "SAP Vendor Invoice Management (VIM) Training", Please Contact Me,We will covers all SAP VIM topics along with end to end ICC, Document pipeline xECM, Enterprise scan etc. Email ID :kakumanusasikanth@gmail.com
Can any one tell me some real time errors you got for support pack apply, During transport request export-import and for db dackup.
What is a background processing batch scheduler?
What is the purpose of webdisptcher and Installing and configuring Web Dispatcher what are the prerequisites?
list some common errors faced with jspm while updating java stcks.and solutions.
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?
If possible send me screenshot doc for installation of ecc6
What will you do if u got Update failure?
Why do you use DDIC user not SAP* for Support Packs and SPam?
Some transactions in sap are seen as customizing, for instance ovrf (updating routes). In some systems this is set as master data and can be set open. Where do you do this?
what are the pre-requisites to apply support patch?