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

Hi can anyone help with projects using load runner. I learnt loadrunner but don't have a hands on experience on it.. it will be very much helpful if some can help me up with a project. can email me: priya.joslic@gmail.com

1727


What are the different sections of the script? In what sequence do these sections run?

1486


What would be your recommendation to improve performance measure?

1110


What are the information contain by script windows for each script in the list?

1127


What is extended log?

1108


What is the load runner testing process?

1262


What are the three sections of a vuser script and what is the purpose of each one?

1029


Suppose ur app server is .net server. In that connection pool is related to memory ?explain how?

2342


What are the section contain by the vugen while creating a vuser script?

1105


What is a difference between pacing and think time?

1049


What is run-time-setting?

1116


How is vugen script modified after recording?

1156


Why do you create parameter?

957


How to create a host list for a scenario?

1155


What is scenario default?

1153