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
Where XML file is generated in solution manager?
How to lock or unlock a transaction code using sm01?
Explain domain controller?
please share sap basis admin interview questions .. thanks sadik
Where is the Deletion Flag or Indicator used in archiving process?
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?
What is JVM switch. Why JVM switch is required ?
Explain reference and service user in sap. What are their uses?
What are the tools to install java patches?
Some transactions in sap are seen as customizing, for instance ovrf (updating routes). In some systems this is set as master data and can be set open. Where do you do this?
What is luw (logical unit of work)?
Explain what is “data sets” in sap?
Explain what is luw (logical unit of work)?
How to transfer request which is created directly on quality server & has to be moved to in production server?
What is rfc connection?