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 did you find database related issues?

Answer Posted / dinesh gawande

If you are using Oracle as database: Oracle comes with a
utility called 'Statspack'. Using statspack you can
identify time/cpu consuming queries, no of hard parses,
queries causing bottlenecks, sequential reads,wait events,
buffer pool advisory, IO statistics and many more things.

When ther is load on the database, generate some statspack
reports and then analyse them. You will get to know/solve
most of the oracle db related issues from statspack report.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to handle the encrypted values in correlation. please send me example with explanation

1636


You have an application which shows the exam results of the student. Corresponding to name of each student its mentioned whether he passed or failed the exam with the label of “pass” and “fail”. How will you identify the number of passed and failed student in vugen script?

1153


What are the element in the loadrunner controller?

1082


What are all the components of loadrunner?

914


What are the different types goals in goal-oriented scenario?

1009


What are the capabilities exactly you look for while selecting the performance testing tool?

1032


How you identify performance test use cases of any application?

967


How can performance bottlenecks be identified?

961


What is the difference between web_reg_find and web_find?

1341


difference between latency and transaction response time

1784


What is stand-alone mode?

1048


What is the think time?

1012


What is remote command launcher?

1078


How does loadrunner execute a performance scenario?

1053


What is the need of checkpoints in lr?

988