Databases Reference
In-Depth Information
In step 3 we investigate the section Top 5 Timed Events, in which a latch-related Latch Free
wait event can indicate an issue in latch contention. In the next screenshot we can see the
result for our test database, resulting in latch-related problems:
In step 4 we verify the Latch Activity section of the report, an excerpt of which is represented
in the next screenshot, where we can find values on sleeps and misses from willing-to-wait
and no-wait latches:
In this section, for each type of latch, we have the statistics for willing-to-wait latch get
requests (Pct Get Miss and Avg Slps/Miss) and for no-wait latch get requests (NoWait
Requests and Pct NoWait Miss). For both types of latches the Pct Misses should be very
close to 0.0, as stated in the heading of this section.
