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
How we tested remote servers if client is installed in another place
difference between latency and transaction response time
What is the basic credentials should be provided while recording SAP-GUI?
What is vugen recording and scripting?
What is parameterization?
How many section database vuser script have?
How are concurrent users differing from simultaneous users?
What is loadrunner api function?
What is the difference between load, performance testing?
How does caching affect performance testing results?
How you load a loadrunner agent?
What is the think time? What is the threshold level for think time and how can be this changed?
How can we debug a loadrunner script?
You have created several auto-correlation rules. A new tester on your team is preparing to record a group of scripts on the same application on his workstation. What can you do to provide the tester with the correlation rules?
How could you measures Https/Sec ?
