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
Explain logon groups?
what are the main issues you faced in the implementation project?
What is an interface in SAP?
What is sap single stack system?
What is ocm and how to apply ocm patches?
How to add authorizations, how you will maintain profiles?
What is the purpose of support package?
TMS Configuration?
Is it possible to install sap patches when other users are online?
What are the daily transactions?
How will you define logon groups ? What is load balancing in sap ?
How you can apply sap notes to sap system?
How client refresh is different than client copy?
How many times bdls transaction executes for 2 clients
What is redolog file? Path?