How to find expensive SQL statement, if found, what should
be done?
- 3 Answers
- 11188 Views
- Wipro, I also Faced
- E-Mail Answers
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
if i want to limit the condition record validity for forst 10 orders how can i do tht plz ans i hve interview in 2/3 days
Explain logon groups?
Explain what is luw (logical unit of work)?
If a background job runs more than the time it should be completed normally then what actions will u take?
What is JVM switch. Why JVM switch is required ?
How will go about doing a client copy ?
How do you kill a job in SAP?
If I want only transaction data to be copied.What profile should I select, while doing local client copy within the same apllication server. Else is there any other way to perform above task?
How you connect ECC to EP?
How can I restrict the user from printing?
How to create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.
How do you distribute the load?
How can you find the list of objects that have been repaired in the system?
What is the difference between st06 and st03?
What is redolog file? Path?
