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

If we have 10 iterations and 20 user, we have to execute 1 iteration by 2 users ... what are the steps for above ?

3 Answers   IBM,


What is stand-alone mode?

0 Answers  


Hi, How can we know that the app deployed in Weblogic Server in percentage?

0 Answers   Symphony,


Dear Gurus, I have an interview in a company in Chicago and my latest project has the following description can anyone let me know what would be the QUESTIONS that can be asked from the following. Thanks,  Developed test cases and test plans and analyzed the test results using for LoadRunner.  Involved in Load/Performance Testing  Created LoadRunner Scenarios and Scheduled the Virtual user to generate realistic load on the server using LoadRunner.  Created and implemented Performance tests using Mercury Interactive LoadRunner.  Enhancing the scripts using Generator and performed Parameterization and Correlation to meet the requirements.  Involved in performing load and stress test on the application and server by configuring LoadRunner to simulate hundreds of virtual users and provided key metrics to the management.  Configured and Using Performance Monitor to monitor and analyze the performance of the server by generating various reports for CPU utilization, Memory Usage, load average etc.  Involved in conducting stress test and volume test against the application using LoadRunner.  Used Quality Centre to invoke the scripts and initially performed the baseline testing and organized all the scripts systematically and generated reports.  Performed regression testing for every modification in the application using Win Runner.  Involved in performance testing of server’s load and scalability by creating multiple Virtual Users by using Load Runner Virtual User Generator component.  Created detailed test status reports, performance capacity reports and graphical charts for upper management using Load Runner analysis component.  Involved in parameterization of script using VuGen in Load Runner. Please.........

1 Answers   ABC,


When do you do load and performance Testing?

2 Answers  






Can We record the Desktop application or windows application in Load Runner(A simple VB application) If yes which mode we have to select while recording in Load Runner?

6 Answers  


What is use of URL Mode Recording?

3 Answers   Honeywell,


how did u do performance testing in ur project?plzzz guys with experience answer in detail, like hw u ppl have used it in ur project. Thanku in advance.

1 Answers  


By default how many virtual user are there in LoadRunner?

2 Answers  


what is the alternative of web_reg_find function?

4 Answers   TATA,


What is main usage and function of MI Listener? Please anyone give me a correct ans.....

2 Answers  


Our desired performance test application where could be installed like(web or app or db server)

0 Answers   Maveric,


Categories