Answer Posted / 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 |
Post New Answer View All Answers
how to get current system time Loadrunner function?
What is the difference between web_reg_find and web_find?
What are all the components of loadrunner?
What are the advantages of load runner?
How to identify what to correlate and what to parameterize?
What are the different components of loadrunner?
What are the loadrunner testing process?
What is elapsed time in load runner?
How can we find database related issues?
Hi all, I am having an interview on LoadRunner (SAP Web Protocol). I am wondering if somebody can help me with some interview questions at a 2 yr Scriptor level. Thanks and all answers are much appreciated.
During the load test, what is the optimum setting for logs?
What is the difference between load, performance testing?
How can performance bottlenecks be identified?
What is run-time-setting?
How are concurrent users differing from simultaneous users?
