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
Explain logon groups?
How should I set priority for Printing say like user, teamlead, project manager?
What is the purpose of webdisptcher and Installing and configuring Web Dispatcher what are the prerequisites?
In my portal ABAP + JAVA I get a bootstrap error message how do I resolve this erroe
What is the purpose of table tadir?
What are the activities you done in EP?
describe where they would look at the buffer statistics, and what steps they would use to adjust them?
what is your project architecture?
I am installing a sap j2ee engine at crm. When it reaches phase 22 it halts for more than 10 minutes and gives up starting the system. What should I do?
Error in the phase import_proper while applying support packages?
What is the database backup strategy in your company?
What is the use of Trusted system? I know that there is no need of UID and PWD to communicate with partner system. In what situation it is good to go for Trusted system?
how can i change access to a user who is having access for SPRO display only to change access in sPro
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?
What is the different type of users in sap?