Interested to Buy Any Domain ? << Click Here >> for more details...
How to find Expensive SQL Statements? How to solve?
- 3 Answers
- 22877 Views
- IBM, I also Faced
- E-Mail Answers
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
How you can disable the ‘import all’ button on stms for the queues?
Explain checkpoint?
How to identify a particular T_Code has been modified or not? If yes, how to identify who modified particular T_Code in current system?
How to make security authorization reports?
Is sap a database ?
How to analysis abap dumps?
Is there a way to perform sapgui 640 roll out using a centralized server?
How to define logon groups?
i want my company code and controlling area defaut as 'ABC" through out SAP what to do ? and my plantcode also default to some value
How you can apply sap notes to sap system?
Using Tc SGEN I have generated 74% job and later I have terminated the job. I wish to start generating from where it stopped I have refreshed but to no chance, nothing was done. How should I further proceed so as to complete the remaining job?
When should we use Transactional RFC?
How to perform a sap-export and import tables in sap from os level?
the difference between part number and serial number
How can I restrict the user from printing?
