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

What is the relation between Response Time and Throughput?

16 Answers   IIT,


In what situation the throughput will decrease even the hits per second increases???

1 Answers   HCL, IBM,


What is Ramp up? How do you set this?

4 Answers  


what is mean by splitfunction give me one example?

1 Answers  


Why vugen is used in lr?

0 Answers  






how to perform load testing of a website using any free automation testing tool?

3 Answers   Tech Mahindra,


How to prepare test data to use in Load runner.

1 Answers   CTS,


Can u plz tell me what r the functions available in load runner and how to write userdefined functions and what are they?

2 Answers  


If it is possible to test 5000 vuser through single machine? Then how you can test? plz explain

2 Answers  


what do you mean by 90 percentile in the Lr report

12 Answers   Contata, Excelacom, TCS, Wipro,


If in an application there are multiple login then where will this transaction go will it be go under init transaction.

1 Answers   IBM,


how to write test cases & test scenarios using loadrunner with examples. plz any one can send the anwser . thank u

1 Answers  


Categories