How are expensive SQL select statements recognized?
Answer Posted / shanker
Use Tcode DBACOCKPIT (ST04) to find SQL statemnts, sort via
the avg elasp time to get expensive SQL statement.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the types of transport queries?
What is JVM switch. Why JVM switch is required ?
What is XI3.0? Explain XI
What do you understand by transport management in sap basis?
what is garbage collector. is there any way to set the time to gc?
What is difference between oracle 9i and oracle 10g?
What is the role of “ application server” ?
When we are doing cash sales, free goods and discount, How many pricing procedure do we need to create..? Only one PP required or have to create multiple PP..? and how many condition type we need to create..?
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.
I'm getting the following runtime error in IDES "DYNPRO_MSG_IN_HELP". GUI is 720 final release and patch level:0
How you will do that?
Explain kernel upgrade?
What are patches you applied?
How many types of printer you have configured? How do you differentiate between them?
Which transaction do you use to check buffer statistics ?