Interested to Buy Any Domain ? << Click Here >> for more details...
How to find Expensive SQL Statements? How to solve?
- 3 Answers
- 22668 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 difference between central instance & application server?
1)Have you used performance tuning? What major steps will you use for these? 2)In production what is the user exit? 3)What type of user exits have you written? 4)Difference between Search Helps and Match Codes 5)On which even we can validate the input fields in module progams? 6)what are the table controls in BDC ? 7)what is the difference between bdc and lsmw ? 8) If the scripts are client dependent, what above driver program ? (client dependent / independent) 9). I have two pages, In one page I want address, Header, Main & footer. In the second page I want only Main. How to do it? 10) Will 50,000 records be uploaded directly into APP's Server? 11) What is the button to change the variant in ALV ? 12) If your project is support project ? when is your implementation has completed ? 13)In start of selection, if we perform validation, what happens ? 12)How to join 3 tallies & looping. We have developed a program in a client say (200- client) and 210 has test data. No developing rights. How to test data? 13)How to transfer data which is coming from are report as output to another report 14)How to create standard text and how do u transfer it ? 15)What are the views when we are creating Material ?
What is the procedure to applying patches?
What will happen during the export process?
Do you have done System copy? What are the steps?
The transaction should not be displayed in User Easy access menu. How to do user auditing in sap? What will u audit?
Explain what is the purpose of tdevc ?
Explain what is sap ides?
In my portal ABAP + JAVA I get a bootstrap error message how do I resolve this erroe
Why can't we do it thru some other client?
What are the key activities that you perform as part of sap basis support?
What is SSO? How to configure SSO?
What is the purpose of table tadir?
I want to change five dialog work processes into batch. Where can I do this?
how can i change access to a user who is having access for SPRO display only to change access in sPro
