How to find expensive SQL statement, if found, what should
be done?
Answer Posted / pwp
ST03N to see the programs having expensive SQL statements
SM50 to see which table is acessing the program
ST04 to see the exact SQL statement and details
STAD/STAT to see more details
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Have u applied patches what is the transaction code?
What are common transport errors and their codes?
How can you define login policy for users in sap system?
What is you allocate disks to different areas in sap?
Explain reference and service user in sap. What are their uses?
User wants lock ASAP then what will u do?
Explain the developer trace?
How to make security authorization reports?
How will u send mail after completion of backup?
Can you tell me about the landscape migration to cloud ?
Explain kernel upgrade?
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.
what is the common storage file for oracle ?
Which transaction do you use to check buffer statistics ?
What do you understand by transport management in sap basis?