Interested to Buy Any Domain ? << Click Here >> for more details...
How to find Expensive SQL Statements? How to solve?
- 3 Answers
- 22631 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
What is the information derived from OSS notes?
I have a requirement from the SD people wherein whenver one runs the tcode F-02 (Enter G/L account Policy : Header Data), they should not get the list of all acounts in the ACCOUNT field. But when i go to pfcg to check for restricting the list, i dont find any pertinet auth field for doing so. Isi t something that we can ( as Basis Admin) do or the ABAPpers to do. Maybe the ABAPpers have to program the screen where in they need to restrict the list options. If not so, lemme know the auth field that has to bet set if any.
What is password policy?
What will you do if u got Update failure?
how would you troubleshoot the 'user can not print'?
Suppose you have to integrate sap ecc 6.0 to aws cloud. How can you achieve this?
How would you troubleshoot the 'system seems slow'?
How to assign a mass Tables in Auth Group by using T-code:se54
What is a background processing batch scheduler?
Explain deletion flag?
How to check cpu usage in EP?
What is Unit Testing in SAP?
A user moved the transport request from dev to qua. How would you trace him?
How many types of work processes are there in sap ?
You want to find out which users have an access to a particulat transaction. How would you do that?
