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 what is business kpis ?
I want to let sap skip printing cover pages during printing for any kind of report. How can this be done?
Difference between system refresh and client copy?
can we give one check for all vendors in automatic payment run? how?
If client copy is stopped in middle, what happens if you want to start it again?
Is it possible to install sap patches when other users are online?
Hi ,All What is the multi-threading and max connections for rfc. Actually i am facing problem while send large amount of idocs to external system using middle ware tibco r3 adapter. And how to enable these in SAP ?
What are the daily transactions?
How you connect ECC to EP?
How to delet a table in sap. How to move a table from one location to another.
What are saplpd and tcp/ip print server and purpose? And difference b/w saplpd and tcp/ip print server?
How many types of work processes?
What is password policy?
The transaction should not be displayed in User Easy access menu. How to do user auditing in sap? What will u audit?
you want to do a system-copy. List the steps you will take.