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

Hi i have 2.10 yrs of experience on Sap Basis...been working as a sap basis consultant.but unable to get through MNC companies...On what criteria does HR select the candidate.does my academics matter coz they are not good thou i am a B.tech graduate

2107


What is the database backup strategy in your company?

2241


Hi All I am Vamshi I Provide Training on ECC Security, Bi Security, HR Security, GRC Access Control Suit(RAR SPM CUP ERM), SRM Security and CRM Security. Duration: 30 days Fees: Rs 7000/- Vamshi Krishna +91-7569362152 email: s.sap30@gmail.com

2294


what is the difference b/w 4.6c & 4.7EE?

2278


What are steps for DB Refresh?

1886


Where will u find transport error logs?

2099


When I check transaction sm37 and I want to see the spool I get a message that says "no list available." Why is this?

1454


what is role of sap administrator in pi & ep?

2464


Explain transport domain?

985


How would you troubleshoot the 'system seems slow'?

1073


What is Unit Testing in SAP?

1263


Explain the developer trace?

1003


What is JVM switch. Why JVM switch is required ?

2608


How to lock or unlock a transaction code using sm01?

2122


What is transport domain?

1831