O'Reilly logo

Oracle Database 11g Release 2 Performance Tuning Tips & Techniques by Richard Niemiec

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

image
CHAPTER
14
Using Statspack and the AWR Report to Tune Waits, Latches, and Mutexes
image
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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required