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
How to set predecessor relationship between two transport requests?
How would you troubleshoot the 'system seems slow'?
What is business kpis ?
How can you find a list of objects that have been repaired in the system?
describe how to setup a printer in SAP or where they would look to research why a user/users can not print?
What are the different types of rfc and explain what transactional rfc is?
How you will give new authorizations?
How to perform a sap-export and import tables in sap from os level?
What are the tools to install java patches?
What is the procedure to applying patches?
describe how SAP handles Memory Management?
How do I know what threshold values to set
Where will u find transport error logs?
What is oracle Architecture?
Hi, Cansomeone please send the system refresh doc , it's very urgent for me. Thanks in advance.