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 do you check the installed software components and product versions on sap system?
Explain what are the functional modules used in sequence in bdc?
Explain what is business kpis ?
If I want only transaction data to be copied.What profile should I select, while doing local client copy within the same apllication server. Else is there any other way to perform above task?
How to uncar car/sar files in a single shot?
How will u send mail after completion of backup?
While doing implementation do you get any issues?
Does any one have SAP basis B1 Resume format for 4 to 5 year experience? if any one have please send me on kishorekharche@gmail.com
What is JVM switch. Why JVM switch is required ?
What is the use of account id in logon tab?
For ex: i scheduled one ABAP program as a background job but it was running 10 days, how to analyze the problem?
When we install sap r/3 enterprise 4.7, there are several error messages in the sapview.log. What does this mean?
Where do you check transport request logs?
steps to congigure CMS in XI ?
What is an interface in SAP?