O'Reilly logo

Oracle Database 11gR2 Performance Tuning Cookbook by Ciro Fiorillo

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

Tuning resources to minimize latch contention

In this recipe we will see how to identify the resources that need to be tuned to minimize latch contention.

Getting ready

In this recipe we will present how to diagnose a latch contention problem using a Statspack report, obtained with the procedures used in Chapter 1.

How to do it...

To identify the resources to be tuned to avoid latch contention we need to:

  1. Execute a Statspack report.
  2. See in the Instance Efficiency Indicators section the value for Latch Hit %.
  3. See in the Top 5 Timed Events section if there is a latch free wait event.
  4. Verify the Latch Activity section to identify the kind of latches that are eventually experiencing misses (and sleeps for willing-to-wait requests).
  5. Verify the Latch Sleep ...

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