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
What is luw (logical unit of work)?
How u will give new authorizations?
User wants lock ASAP then what will u do?
What is SSO? How to configure SSO?
What is JVM switch. Why JVM switch is required ?
Where is the Deletion Flag or Indicator used in archiving process?
How do you check the users logs in your system and how many sessions each user is generating?
Mention what is the difference between sdm and jspm?
What do you understand by sap client administration?
what is garbage collector. is there any way to set the time to gc?
Explain how client refresh is different than client copy?
When we install sap r/3 enterprise 4.7, there are several error messages in the sapview.log. What does this mean?
you want to do a system-copy. List the steps you will take.
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?
Can you tell me about the landscape migration to cloud ?