How to find expensive SQL statement, if found, what should
be done?
Answer Posted / ananth
Sto4 we can see the Expensive SQL statements with the help
of the Cost
sto4 --- Detail Analysis menu ----Oracle session--- Find
with the help of PID and Explain.
if we Found Expensive SQL statement Analyze those Index's
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Can you change the profile parameter in the os level? Which one is advisable why?
If a user complaints that he could not execute some of the transaction codes then what will you do?
What is JVM switch. Why JVM switch is required ?
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?
How to create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.
Explain how client refresh is different than client copy?
How many types of work processes?
How do you check the installed software components and product versions on sap system?
How you will get help from OSS notes?
Explain how you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?
Hi i am Ramesh want to know that which course in sap is most suitable for my younger brother who has BSC qualification and is this course is job oriented
What are the daily transactions?
How to update SAP
What are the different types of job status? Can you unschedule an active job?
what are the pre-requisites to apply support patch?