Interested to Buy Any Domain ? << Click Here >> for more details...
how to know if there are expensive sql statements
running?what will you do then to improve the response time?
- 3 Answers
- 12569 Views
- Atos Origin, I also Faced
- E-Mail Answers
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
Do you know logon groups at which situation will be created logon group?
What are steps for DB Refresh?
What is the information derived from OSS notes?
Can anyone help me in educating me in installing SAP 4.6C over windows server 2000. Please make it a step by step process, my career depends upon the success and failure of installation.
Explain the developer trace?
Explain the system log?
What is sap single stack system?
Mention what is the purpose of table usr02?
what is the difference between with core
What is XI3.0? Explain XI
For ex: i scheduled one ABAP program as a background job but it was running 10 days, how to analyze the problem?
Using Tc SGEN I have generated 74% job and later I have terminated the job. I wish to start generating from where it stopped I have refreshed but to no chance, nothing was done. How should I further proceed so as to complete the remaining job?
Where XML file is generated in solution manager?
Is there a way to perform sapgui 640 roll out using a centralized server?
What are the activities you done in EP?
