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

How you will get help from OSS notes?

1984


What are the different types of rfc?

1039


Explain logon load balancing?

1057


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

2528


Can any one tell me , what is the role of SAP Security Admin in BW Security and APO Security ?

1976


Explain what is the purpose of tdevc ?

1102


What is the difference between kernel replacement and support package?

1136


Explain deletion flag?

1045


What will happen during the export process?

1982


My Apologies, The previous questions were concerning the Transaction ST02

2125


How to apply java stacks ? expalin step by step prcoess

1891


How would you troubleshoot the 'system seems slow'?

1021


Transport request types and its syntax?

2362


What is a support package?

932


How to perform a sap-export and import tables in sap from os level?

1239