Interested to Buy Any Domain ? << Click Here >> for more details...
How to find Expensive SQL Statements? How to solve?
- 3 Answers
- 22632 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
A user moved the transport request from dev to qua. How would you trace him?
Mention what is the difference between sdm and jspm?
How to delet a table in sap. How to move a table from one location to another.
What is a developer key? and how to generate a developer key?
Why we execute SGEN, which Tables it modifies,will it cause DB growth? is it possible to execute SGEN later on after Golive?
How you will do that?
Does any one have SAP basis B1 Resume format for 4 to 5 year experience? if any one have please send me on kishorekharche@gmail.com
What will you do if u got Update failure?
How can you find a list of objects that have been repaired in the system?
can u explain step by step procedure of DB REFRESH..Ravi
How you will get help from OSS notes?
Explain the system log?
what is the use of psapundo tablespace? what is the error ora -01555 represents.how can u prevent this error?
How database extend?
Where is the Deletion Flag or Indicator used in archiving process?
