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
Hi can anyone help with projects using load runner. I learnt loadrunner but don't have a hands on experience on it.. it will be very much helpful if some can help me up with a project. can email me: priya.joslic@gmail.com
What are the different sections of the script? In what sequence do these sections run?
What would be your recommendation to improve performance measure?
What are the information contain by script windows for each script in the list?
What is extended log?
What is the load runner testing process?
What are the three sections of a vuser script and what is the purpose of each one?
Suppose ur app server is .net server. In that connection pool is related to memory ?explain how?
What are the section contain by the vugen while creating a vuser script?
What is a difference between pacing and think time?
What is run-time-setting?
How is vugen script modified after recording?
Why do you create parameter?
How to create a host list for a scenario?
What is scenario default?