Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Explain what is “data sets” in sap?

1239


What is process for applying patches?

1141


How do you solve oracle archive struck?

1927


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?

2021


What are the activities you done in EP?

1729


How do you distribute the load?

1127


How to transport objects from Production to Development?

2175


What are common background jobs that will run in your system?

2601


steps to congigure CMS in XI ?

2329


If brtools is not working how you will add datafile?

2532


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?

1872


How you connect ECC to EP?

2041


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?

1075


what is netweaver

1562


How you will rate yourself in SAP, Oracle from a scale 1 - 10?

2497