Examples of common tools, methods for diagnosing Oracle performance problems

Examples of common tools, methods for diagnosing Oracle performance problems

Answer: 1) A simple point can be used toad and dbartisan such tools. 2) Pure performance monitoring, more excellent spolight and EMC I3, both of these software are more expensive. 3) Some network management systems are also good, such as HP's OpenView. But it's not easy and expensive to customize.

4) It's Oracle's statpack that doesn't cost and works. 5) Then there is the script, and most experienced dbas like it that way. The advantages are practical and flexible. The disadvantage is that if you come up with a graph of performance changes and other diagrams, and do the aesthetics of the need for some delphi,c++builder or PB development skills.

Examples of common tools, methods for diagnosing Oracle performance problems