how to know if there are expensive sql statements
running?what will you do then to improve the response time?
Answer Posted / venkatesan k
ST03 ---> Detailed Analysis--> Transaction profile-->
Standard--> Selectb task type as DIA---> Sort the Totao DB
time in Ascending order
ST04--> detailed Analysis--> Resourse Consuption--> Oracle
Seeion Monitor--> Identify the long running task by
comparing that with WP Id.
Double click on the task --> resulting DIA Box--> Explain
SQL statement-->Analyse
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain deletion flag?
What is transport domain?
Hi All I am Vamshi I Provide Training on ECC Security, Bi Security, HR Security, GRC Access Control Suit(RAR SPM CUP ERM), SRM Security and CRM Security. Duration: 30 days Fees: Rs 7000/- Vamshi Krishna +91-7569362152 email: s.sap30@gmail.com
Which are the most frequent errors encountered while dealing with transports ?
How you can apply sap notes to sap system?
What is SSO? How to configure SSO?
How you can assign an object to 100 roles at time?
What are the daily activates?
What is upgrade process? And how u will do that?
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).
How can you define login policy for users in sap system?
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?
Explain segment?
What is the system's configuration required to implement SAP.
What is the role of “ application server” ?