Interested to Buy Any Domain ? << Click Here >> for more details...
How to find Expensive SQL Statements? How to solve?
- 3 Answers
- 22834 Views
- IBM, I also Faced
- E-Mail Answers
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
What are the categories to execute sap background jobs?
What is the purpose of webdisptcher and Installing and configuring Web Dispatcher what are the prerequisites?
How will you define logon groups ? What is load balancing in sap ?
What is R/3? and what is basis version?
what is the difference between with core
What is redolog file? Path?
Screenshot document for solution manager installation.
can u explain step by step procedure of DB REFRESH..Ravi
Explain the architecture of sap system with different layers. What is the use of gateway?
What is the database backup strategy in your company?
Is there any report or table in which user log off time is stored in sap?
How to add authorizations, how you will maintain profiles?
For ex: i scheduled one ABAP program as a background job but it was running 10 days, how to analyze the problem?
Explain what is the purpose of tdevc ?
Where will you change the parameters in three profiles?
