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 handle the encrypted values in correlation. please send me example with explanation
You have an application which shows the exam results of the student. Corresponding to name of each student its mentioned whether he passed or failed the exam with the label of “pass” and “fail”. How will you identify the number of passed and failed student in vugen script?
What are the element in the loadrunner controller?
What are all the components of loadrunner?
What are the different types goals in goal-oriented scenario?
What are the capabilities exactly you look for while selecting the performance testing tool?
How you identify performance test use cases of any application?
How can performance bottlenecks be identified?
What is the difference between web_reg_find and web_find?
difference between latency and transaction response time
What is stand-alone mode?
What is the think time?
What is remote command launcher?
How does loadrunner execute a performance scenario?
What is the need of checkpoints in lr?