How to find Expensive SQL Statements? How to solve?
Answer Posted / rout
U can find expensive SQL statements using T_code:ST05 /SM50
U can solve this either by killing the process or find out
the table that has been accessed adn creat some indexes ,so
that it can be accessed easily or get the workload
statestics information and tune the system.
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
Explain logon load balancing?
What is JVM switch. Why JVM switch is required ?
Myself Rahul am MBA(Mkt)having 1.5 years marketing experience.and in SAP-SD for 1 years experience.am looking for job.so pl anywher opening then pl let me revert.
At os level how you can change the number of work process? How you can analyze the status of work process at os level?
what is the difference b/w 4.7EE & ECC5.0?
Mention what is the purpose of table usr02?
Explain what is luw (logical unit of work)?
the difference between part number and serial number
User wants lock ASAP then what will u do?
What is XI3.0? Explain XI
What is upgrade process? And how u will do that?
Where will you change the parameters in three profiles?
how can i change access to a user who is having access for SPRO display only to change access in sPro
Where is the Deletion Flag or Indicator used in archiving process?
Explain kernel upgrade?