How did you find database related issues?
Answers were Sorted based on User's Feedback
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 |
Answer / anaz
By Using Database Monitors and DB Resource graph will give
the information for DB
| Is This Answer Correct ? | 4 Yes | 0 No |
What the host attributes determine?
What is a correlation? Explain the difference between automatic correlation and manual correlation?
When the rendezvous point is insert?
In which scenario, we should use "Vuser as Process" rather than "Vuser as thread" and what is benefit in this case?
What is Injector in Loadrunner?
I am facing the active Screen Problem in loadrunner.While runnning the script active screen pop up is dispalying, always asking for username and password.This popup having OK,Cancel and HELP buttons.After clicking any OK or CANCEL button , then only it is moving to next step.What can i do? Please give any suggestion...
what is loadrunner?
The response time of an application was 2.5 seconds.After a minor hotfix,the response time increased to 5 seconds.What analysis can you make out. What are all the things u check in the server side in such a scenario?
Why we insert the rendezvous point while running the scenario?
How does caching affect performance testing results?
What are the drawbacks of LoadRunner tool?
When we go for manula correlation, automation correlation Expl?(Chandana) Real timers Plz