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 extended log?
What are the information contain by script windows for each script in the list?
What is script list?
Explain the difference between automatic correlation and manual correlation?
What is parameterization?
when i run start senario for different process it always completed at elapsed time 6.32 sec. i don't understand why it happens.. can we set elapsed time ? plz answer.... pratik196@gmail.com
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?
How you develop the database vuser script?
When loadrunner is used?
Does caching have a negative effect on your load testing results?
What type of function generate and insert by the vugen to the script when you record a script?
How to record the desktop application in Loadrunner 12.53 version 64 bit window.
What are the different sections of the script? In what sequence do these sections run?
While the script is running we find some values that may need to be correlated? Is it possible to do manual correlation for those values?
How can we find database related issues?