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 vugen create a vuser script?
How are concurrent users differing from simultaneous users?
What do vuser_init and vuser_end action contain?
What component of loadrunner is used to record a script?
What are the three sections of a vuser script and what is the purpose of each one?
What is the process for developing a vuser script?
What is the difference between load, performance testing?
How you develop the database vuser script?
How can you set the number of vusers in loadrunner?
What is a correlation?
What is the vuser in the scenario?
How do you enable text and image checks in vugen?
What is a difference between pacing and think time?
What is the basic credentials should be provided while recording SAP-GUI?
What is the modular approach of scripting?
