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 ocm and how to apply ocm patches?
Why do you use DDIC user not SAP* for Support Packs and SPam?
How many types of work processes?
What is the purpose of support package?
what is the common storage file for oracle ?
What are the different types of sap profiles?
What are the different types of rfc and explain what transactional rfc is?
what is your project architecture?
Screenshot document for solution manager installation.
What is private mode? When does user switch to user mode?
How do you check the installed software components and product versions on sap system?
What is the difference between st06 and st03?
Where do you download trail version of sap ecc, what is sap cal?
What are the categories to execute sap background jobs?
Explain logon groups?