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 know if there are expensive sql statements
running?what will you do then to improve the response time?

Answer Posted / venkatesan k

ST03 ---> Detailed Analysis--> Transaction profile-->
Standard--> Selectb task type as DIA---> Sort the Totao DB
time in Ascending order

ST04--> detailed Analysis--> Resourse Consuption--> Oracle
Seeion Monitor--> Identify the long running task by
comparing that with WP Id.
Double click on the task --> resulting DIA Box--> Explain
SQL statement-->Analyse

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is business kpis ?

1124


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

1141


Difference between system refresh and client copy?

2822


can we give one check for all vendors in automatic payment run? how?

2163


If client copy is stopped in middle, what happens if you want to start it again?

2081


Is it possible to install sap patches when other users are online?

1035


Hi ,All What is the multi-threading and max connections for rfc. Actually i am facing problem while send large amount of idocs to external system using middle ware tibco r3 adapter. And how to enable these in SAP ?

2368


What are the daily transactions?

1105


How you connect ECC to EP?

2033


How to delet a table in sap. How to move a table from one location to another.

2273


What are saplpd and tcp/ip print server and purpose? And difference b/w saplpd and tcp/ip print server?

3171


How many types of work processes?

1135


What is password policy?

1231


The transaction should not be displayed in User Easy access menu. How to do user auditing in sap? What will u audit?

2488


you want to do a system-copy. List the steps you will take.

997