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

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?

948


what is remote performance monitering?

1876


What the vuser script contain?

809


How we tested remote servers if client is installed in another place

1956


What is difference between manual scenario and goal oriented scenario?

799


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

777


What are the challenges that you will face to script the step “select all” and then “delete” for any mail account?

1198


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

1498


Which components have you used in loadrunner ?

753


What is the process for developing a vuser script?

766


How you load a loadrunner agent?

897


What are the types of checkpoints is available in loadrunner?

902


What is the load runner testing process?

808


Does caching have a negative effect on your load testing results?

852


What are different types of vuser logs which can be used while scripting and execution? What is the difference between these logs? When you disable logging?

814