Interested to Buy Any Domain ? << Click Here >> for more details...
How to find Expensive SQL Statements? How to solve?
- 3 Answers
- 22826 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 are the different login and password parameters that can be applied in sap system?
What are the key responsibilities of sap basis administrator?
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?
Explain checkpoint?
Can anyone help me in educating me in installing SAP 4.6C over windows server 2000. Please make it a step by step process, my career depends upon the success and failure of installation.
How to check cpu usage in EP?
What is the purpose of support package?
I want to change five dialog work processes into batch. Where can I do this?
Explain the architecture of sap system with different layers. What is the use of gateway?
How you connect ECC to EP?
IN FUNCTIONAL MODULE SD WE UNFORTUNETLY DELETE OUR ONE ITEM CATEGORY "TAN" FOR THAT WE WANT RECOVER IT WHAT ARE THE PROCEDURES. IS THERE ANY PROCEDURES LIKE RECYCLEBIN. TELL US DETAIL PROCEDURES STEP BY STEP PLEASE
What are the different modules of SAP?
Error in the phase import_proper while applying support packages?
Suppose you have to integrate sap ecc 6.0 to aws cloud. How can you achieve this?
How will u send mail after completion of backup?
