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 are the changes that can be made to run-time settings?
How we tested remote servers if client is installed in another place
What is elapsed time in load runner?
I have one Scenario login then bookcoffee then logout explain test plan for above scenario?
What is the difference between lr_error_message and lr_debug _message?
What is x-windows?
What are different types of vuser logs which can be used while scripting and execution?
What is the significance of “vuser-init “?
When a scenario run exactly what happened?
What is transaction per second graph(pass)?
What tools are required to analyze vuser run results?
What is the purpose of a loadrunner transaction?
What are the different sections of the script? In what sequence do these sections run?
What is report header and what are the information contains?
what is remote performance monitering?