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
Can you tell me installation procedure of SAP on UNIX
If job is slow?
What is transport layer and domain controller? In which system you have create domain control?
If a user complaints that he could not execute some of the transaction codes then what will you do?
What is oracle Architecture?
What is MySAP?
What are the tools to install java patches?
In my portal ABAP + JAVA I get a bootstrap error message how do I resolve this erroe
What is difference between oracle 9i and oracle 10g?
Have u applied patches what is the transaction code?
I have a requirement from the SD people wherein whenver one runs the tcode F-02 (Enter G/L account Policy : Header Data), they should not get the list of all acounts in the ACCOUNT field. But when i go to pfcg to check for restricting the list, i dont find any pertinet auth field for doing so. Isi t something that we can ( as Basis Admin) do or the ABAPpers to do. Maybe the ABAPpers have to program the screen where in they need to restrict the list options. If not so, lemme know the auth field that has to bet set if any.
you want to take sap backup using brtools. How would you do that?
can we give one check for all vendors in automatic payment run? how?
What do you understand by sap client administration?
How to update SAP