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

Hi i have installed LR 8.0v on my system and wanted to test siebel web application. when i tried to record the application throught siebel web protocol, the launcher tries to connect to that URL but after some time the URL gives as Page Cannot Be Displayed, the same URL when we login manually it works fine. LR is not able to connect to the Application. What could be the reason?

1 Answers   HP,

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

1 Answers   IBM,

What are the components of LoadRunner?

21 Answers  

Analysis Scenario (Bottlenecks):?

2 Answers  

how memory will be used in the JVM.With think time .what is necessary of the think time in loadrunner

1 Answers   HCL,

What are the components of LoadRunner?

5 Answers  

difference between GET & POST methods in JAVA?

1 Answers  

1.How can you Calculate load / stress testing in manually ?

1 Answers   Ness Technologies,

why parameterization is necessary when load testing the web server and the data base server ?

4 Answers  

What are deliverables in performance test analysis ?

3 Answers  

if we have licence for 200 vuser and if we u want to get performance matrix to 300 vuser how will u perform

6 Answers   Syntel,

I am not able to access controller machine and I have to run test. How would I handle this situation?

1 Answers   Infosys,