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
Hi i have 2.10 yrs of experience on Sap Basis...been working as a sap basis consultant.but unable to get through MNC companies...On what criteria does HR select the candidate.does my academics matter coz they are not good thou i am a B.tech graduate
What is the database backup strategy in your company?
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
what is the difference b/w 4.6c & 4.7EE?
What are steps for DB Refresh?
Where will u find transport error logs?
When I check transaction sm37 and I want to see the spool I get a message that says "no list available." Why is this?
what is role of sap administrator in pi & ep?
Explain transport domain?
How would you troubleshoot the 'system seems slow'?
What is Unit Testing in SAP?
Explain the developer trace?
What is JVM switch. Why JVM switch is required ?
How to lock or unlock a transaction code using sm01?
What is transport domain?