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 advantage of running vuser as a process than a thread?

0 Answers  


What are monitors?

0 Answers  


What do you mean by initialization of quota?

0 Answers  


whar r the benfits of Load Controlar?

1 Answers  


when i run start senario for different process it always completed at elapsed time 6.32 sec. i don't understand why it happens.. can we set elapsed time ? plz answer.... pratik196@gmail.com

0 Answers  


How do you estimate test duration in LoadRunner?

0 Answers   Allianz,


How is the 90 percentile calculated? Say I am having total 2000 transactions pumped to the system and I have 1800 passed and 200 failed. So the 90 pertile is considered from the Passed transactions or (passed+failed) transactions?

4 Answers   HP,


Can u call QTP scripts from Load Runner?

4 Answers  


What is the difference between standard log and extended log?

4 Answers  


What is think time? How do you change the threshold?

6 Answers  


Hi anyone please share the load runner error messages

3 Answers   Cognizant,


What is the use of lr_start_transition statement in loadrunner.

1 Answers  


Categories