Using Statspack to solve Performance Problems Reactively

Statspack is a performance diagnosis tool, available with Oracle8i Release 8.1.6. Statspack can
be considered BSTAT/ESTAT's successor, incorporating many new features, such as:
• Storing performance data in permanent Oracle tables which can be used for analysis at any
time in the future
• Capturing high-resource SQL statements
• An easy to use report, with many useful ratios pre-computed
• The ability to be run on all nodes of an OPS system

Refer: http://www.oracle.com/technology/deploy/performance/pdf/statspack_tuning_otn_new.pdf