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
What is the rendezvous point?
How load runner interacts with the application?
What is a correlation? Explain the difference between automatic correlation and manual correlation?
Hi all, I am new to Load Runner. I have run the load runner and i got analyzed reports/graphs. But i am very much confused about how to analyze those graphs. Can any one help me out this problem?
What is the difference between web_reg_find and web_find?
What is a difference between pacing and think time?
When the loadrunner controller open the winrunner file then what is the location of the winner configuration file?
You want to have each step in your script measured as a transaction in the controller and not shown in the replay log in vugen. How can you accomplish this?
What is the difference between load, performance testing?
What do you mean by creating vuser script?
How is vugen script modified after recording?
What are the section contain by the vugen while creating a vuser script?
What are the information contain by script windows for each script in the list?
What is parameterization?
How is each step validated in the script?
