Interested to Buy Any Domain ? << Click Here >> for more details...
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 difference between transaction and transaction instance in loadrunner ?
What is ms-windows?
What is run-time-setting?
How you identify performance test use cases of any application?
What is a ramp up and how it can be set?
What is remote command launcher?
What is loadrunner api function?
What is scenario default?
What is the need of checkpoints in lr?
What is vuser-end section?
What is elapsed time in load runner?
How can we find database related issues?
What component of loadrunner is used to record a script?
Which are online monitors and windows resource monitors
how to add 100 for dynamic(correlate value) value
