O'Reilly logo

Oracle Database 12c 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

Images

CHAPTER

14

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, you should choose Enterprise Manager (Chapter 5) and the Automatic Workload Repository (AWR) Report and/or Statspack (both covered in this chapter). In Oracle 12cR2, the AWR Report has much more information than you can find with Statspack—and a whole lot more when it comes to impact tuning! Statspack remains in 12cR2 but has few improvements and does not currently include In-Memory statistics. The Statspack utility has been available and free since Oracle 8.1.6 ...

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