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
How you will get help from OSS notes?
What are the different types of rfc?
Explain logon load balancing?
What are common background jobs that will run in your system?
Can any one tell me , what is the role of SAP Security Admin in BW Security and APO Security ?
Explain what is the purpose of tdevc ?
What is the difference between kernel replacement and support package?
Explain deletion flag?
What will happen during the export process?
My Apologies, The previous questions were concerning the Transaction ST02
How to apply java stacks ? expalin step by step prcoess
How would you troubleshoot the 'system seems slow'?
Transport request types and its syntax?
What is a support package?
How to perform a sap-export and import tables in sap from os level?