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 manual tester daily process is ..study the req.s preparing test scenarios & writing the t.cs and finding bugs and send to the devoloper......SIMILARLY PLS TELL THE LOAD RUNNER DAILY PROCESS FROM INITIAL STAGE TO FINAL STAGE...? daily process..performance tester use any DOCUMENT...like TCD?

1 Answers  


How many values can be generating in script we can Parameterize even it is in one scenario 1000Parameterization values are there it is correct to Parameterized?or not?

1 Answers   Accenture,


what is connection pooling?

1 Answers  


where we can insert the defects in load runner?

1 Answers  


What is a function to capture dynamic values in the web vuser script?

5 Answers  


What is the Diffrence between Clint server & Web based application ? plz Explain in detail (Chandana)

1 Answers   IBM,


hai friends, it s very urgent ...pls do help me out ...... please to help in working with load runner to find the response time of single user,5 user etc.... i dont have any prior experience but i am in the situation to handle this scenario.....its very urgent ...pls help me

2 Answers  


What is local configuration file?

0 Answers  


how test an real time application using the loadrunner .plz give me an example

1 Answers  


How is each step validated in the script?

0 Answers  


How is automated correlation configured?

0 Answers  


Hi I want to learn Performance testing using load runner..Can anyone suggest me which is the best institute for load runner in bangalore??

6 Answers  


Categories