How to find Expensive SQL Statements? How to solve?
Answer Posted / venkat
To find expensive sql statement.
Goto DBACOCKPIT ->performance->SQL statement Analysis->shared cursor cache [sap net weaver]
Goto ST04 -> Detailed Analysis Menu -> SQl Request -> Sort by disk reads/ buffer gets / executions.
goto ST05 and find out the sql statements whic consumes more than are around 50000 records are reads.
you have to work with DBA people to finetune them
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What do you understand by sap client administration?
Hi,My name is Saurabh I have done BMS & currently working in Wipro BPO (1 year). I want to pursue my career in SAP. As I am totally new in the IT field(no course & no experience) Please could you suggest whether to do a certification from Certified institutes or Non Certified institutes.What is the difference? Also, Is MBA necessary to do certification from Certified institutes?
What is the use of kernel in sap system? How do you check the current kernel version in sap system?
What is the purpose of webdisptcher and Installing and configuring Web Dispatcher what are the prerequisites?
How database extend?
dear friends, HOW TO CONFIGURE INTO ABAP WEB DYNPRO AND ADOBE OF ECC6.0 R/3 IDES SYSTEM?
Screenshot document for solution manager installation.
What are the different types of sap profiles?
How you will rate yourself in SAP, Oracle from a scale 1 - 10?
what is the procedure for java stack upgradation?
How do you check the installed software components and product versions on sap system?
Why can't we do it thru some other client?
Have you done any parameter changes using configtool and visual admin tool?
Explain the architecture of sap system with different layers. What is the use of gateway?
What are common transport errors and their codes?