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 a rendezvous point?

7 Answers  


How a request is routed (request flow) in an n-tier architecture. digramatically explain a basic n-tier architecture.

1 Answers   Wipro,


Where Can i get the Best training on Loadrunner

4 Answers  


Hi all, I am new to Load Runner. I have run the load runner and i got analyzed reports/graphs. But i am very much confused about how to analyze those graphs. Can any one help me out this problem?

0 Answers  


What are the main Performance issues in JBoss server? And How to do it?

1 Answers  






which kind of database counters we use to check the performance of the software and where we can check them?

1 Answers  


what is the differance between standard log and extended log?

5 Answers  


What is the purpose of a loadrunner transaction?

0 Answers  


What are monitors?

0 Answers  


When Do u Do LoadTesting and When You do StressTesting? What settings you have to changes for loadtesting and stress testing?

2 Answers   Infosys, Mind Tree,


When do you disable log in Virtual User Generator, When do you choose standard and extended logs?

1 Answers  


When the loadrunner controller open the winrunner file then what is the location of the winner configuration file?

0 Answers  


Categories