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 to find expensive SQL statement, if found, what should
be done?

Answer Posted / naveen

Use TCode ST03N.Go to transaction profile and see 0DB Time
and 0 Responce time.
Check the Average sequential Read time by STAT and STAD.
Select the object in Red and

Is This Answer Correct ?    0 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is transport layer and domain controller? In which system you have create domain control?

1845


What is MySAP?

1087


How can a user be able to access only for Customizing requests even if assigned se01 and se10?.

3076


How you can assign an object to 100 roles at time?

1382


How do you check the users logs in your system and how many sessions each user is generating?

1023


How u will give new authorizations?

1884


how can i change access to a user who is having access for SPRO display only to change access in sPro

2296


How you can disable the ‘import all’ button on stms for the queues?

1131


What do you understand by sap client administration?

1085


How many types of work processes are there in sap ?

1108


I have a requirement from the SD people wherein whenver one runs the tcode F-02 (Enter G/L account Policy : Header Data), they should not get the list of all acounts in the ACCOUNT field. But when i go to pfcg to check for restricting the list, i dont find any pertinet auth field for doing so. Isi t something that we can ( as Basis Admin) do or the ABAPpers to do. Maybe the ABAPpers have to program the screen where in they need to restrict the list options. If not so, lemme know the auth field that has to bet set if any.

2101


How you will give new authorizations?

1804


I want to let sap skip printing cover pages during printing for any kind of report. How can this be done?

1096


Have u applied patches what is the transaction code?

999


How many types of work processes?

1107