Using Statspack and the AWR Report to Tune Waits, Latches, and Mutexes
If you could choose just two Oracle utilities to monitor and find performance problems on your system, those two utilities would be Enterprise Manager (Chapter 5) and the AWR (Automatic Workload Repository) Report and/or Statspack (both covered in this chapter). In Oracle 11gR2, the AWR Report has everything that is in Statspack—and a whole lot more! Statspack remains in 11gR2 but has few improvements. The Statspack utility has been available since Oracle 8.1.6 to ...