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
In the Sap Easy Access Menu I see the menu System -> User Profiles ->Own Data. Other options Hold Data is to keep data values that you have entered in a field of an application for the duration of the session; SET DATA not to overwrite the data and DELETE DATA to delete the set data. Can somebody explain me the Hold Data, Set Data and Delete Data with examples, i mean giving an example of fields?
What are the different user types in sap system that an admin can use while creating a new user?
On a particular system how you can get a list of the users with development access on a particular system?
what is the procedure for java stack upgradation?
Which are the most frequent errors encountered while dealing with transports ?
Is system user sap basis consultant and dialogue user other user like fico, hr, mm user?
What is the system's configuration required to implement SAP.
What is a support package? What is its purpose?
What is an interface in SAP?
How to transfer request which is created directly on quality server & has to be moved to in production server?
What is the folder it will ask to install oracle?
What is transport layer and domain controller? In which system you have create domain control?
1)Have you used performance tuning? What major steps will you use for these? 2)In production what is the user exit? 3)What type of user exits have you written? 4)Difference between Search Helps and Match Codes 5)On which even we can validate the input fields in module progams? 6)what are the table controls in BDC ? 7)what is the difference between bdc and lsmw ? 8) If the scripts are client dependent, what above driver program ? (client dependent / independent) 9). I have two pages, In one page I want address, Header, Main & footer. In the second page I want only Main. How to do it? 10) Will 50,000 records be uploaded directly into APP's Server? 11) What is the button to change the variant in ALV ? 12) If your project is support project ? when is your implementation has completed ? 13)In start of selection, if we perform validation, what happens ? 12)How to join 3 tallies & looping. We have developed a program in a client say (200- client) and 210 has test data. No developing rights. How to test data? 13)How to transfer data which is coming from are report as output to another report 14)How to create standard text and how do u transfer it ? 15)What are the views when we are creating Material ?
Where will u find transport error logs?
What are the scripts you can create for security by using LSMW??