How to find Expensive SQL Statements? How to solve?
- 3 Answers
- 21913 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
Explain what is luw (logical unit of work)?
How to check CPU usage in EP? If java path is down the how to do trouble shoot? What is the transport group? What is the SLD system in PI? How to take back up in EP? How to create logical system? Is it possible to change the name logical system in SSC4? How you will take the online Backup and incremental Backup? What is the backup strategy? How many application servers you have in Production System? Difference between oracle 9i and oracle 10g? What is EHP4? What is your enhancement package and support package? how to find RAM size on Unix? How to find OS level at command Prompt? While doing kernel upgrade what is exe files? What is client comparison? How to apply job on Os level? What are the recent challenges faced? How to apply support package in solution manager? Difference between SPDD/SPAU If SAP* is not working ? If job is slow? how you will trouble shoot? What are software files required for SAP 4.7?
What is the difference between kernel replacement and support package?
What are the different types of sap profiles?
what is role of sap administrator in pi & ep?
How client refresh is different than client copy?
what is the procedure for java stack upgradation?
How to perform the transport?
How to configure TMS?
What are the errors you got while applying support pack?
What is ocm and how to apply ocm patches?
What is the difference between central instance & application server?
If brtools is not working how you will add datafile?
What is private mode? When does user switch to user mode?
i'm new for security, pls help if assign the t-code to parent it wll effect to child role or not. can we assign to t-code directly to child role? it wll work or not?
