How did you find database related issues?

Answers were Sorted based on User's Feedback

How did you find database related issues?..

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

How did you find database related issues?..

Answer / anaz

By Using Database Monitors and DB Resource graph will give
the information for DB

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Load Runner Interview Questions

Which are online monitors and windows resource monitors

0 Answers   Cap Gemini,

What do you mean by initialization of quota?

0 Answers  

can u name some of the important functions in LoadRubber Scripting?

1 Answers   CTS,

What is stand-alone mode?

0 Answers  

in general best o/s should posses max CPU utilization.but in loadrunner we consider CPU utilization exceed 70% it is a bottleneck in CPU.explain why?

4 Answers   Symphony, Tata Communications, HCL,

What is x-windows?

0 Answers  

What is transaction per second graph(pass)?

0 Answers  

what are the type of recording modes available in LR? on what basis we will select each?

2 Answers  

What is the use of lr_start_transition statement in loadrunner.

1 Answers  

AFter generation the script for a application i am trying to make correlation but it is showing 404 error after customization.could u please help me how i have to make correlation give me steps please

3 Answers  

what usually indicates that ur virtual user script has dynamic data that is dependent on u parameterized fields?

2 Answers   IBM,

What do I need to know to do load testing in addition to knowing how to use the loadrunner tool?

0 Answers