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 / ananth

Sto4 we can see the Expensive SQL statements with the help
of the Cost
sto4 --- Detail Analysis menu ----Oracle session--- Find
with the help of PID and Explain.

if we Found Expensive SQL statement Analyze those Index's

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you change the profile parameter in the os level? Which one is advisable why?

1306


If a user complaints that he could not execute some of the transaction codes then what will you do?

1117


What is JVM switch. Why JVM switch is required ?

2647


In the Sap Easy Access Menu I see the menu System -> User Profiles ->Own Data. Other options Hold Data is to keep data values that you have entered in a field of an application for the duration of the session; SET DATA not to overwrite the data and DELETE DATA to delete the set data. Can somebody explain me the Hold Data, Set Data and Delete Data with examples, i mean giving an example of fields?

3881


How to create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.

3708


Explain how client refresh is different than client copy?

1344


How many types of work processes?

1183


How do you check the installed software components and product versions on sap system?

1065


How you will get help from OSS notes?

2109


Explain how you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?

1290


Hi i am Ramesh want to know that which course in sap is most suitable for my younger brother who has BSC qualification and is this course is job oriented

2108


What are the daily transactions?

1147


How to update SAP

1897


What are the different types of job status? Can you unschedule an active job?

1196


what are the pre-requisites to apply support patch?

1130