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
Explain what is “data sets” in sap?
What is process for applying patches?
How do you solve oracle archive struck?
suppose in the landscape there is development, quality, pre-production and production system is there. what is the route(transport route) between pre-production to production? and why?
What are the activities you done in EP?
How do you distribute the load?
How to transport objects from Production to Development?
What are common background jobs that will run in your system?
steps to congigure CMS in XI ?
If brtools is not working how you will add datafile?
A transport is imported into QAS in 2 min. time the same transport when imported into PRD is taking more than 20 min. why? What to do?
How you connect ECC to EP?
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 netweaver
How you will rate yourself in SAP, Oracle from a scale 1 - 10?