Home › Discussions › Questions & Answers › Investigating High Latch Misses and Wait Times

Investigating High Latch Misses and Wait Times

Avatar photoCustomer Questions & Answers 5 replies

We have performance bottlenecks characterized by high latch misses and wait times. How can I analyze the latch statistics over a specified historical snapshot interval?

5 replies

  • Support Enginatics

    You should use the DBA AWR Latch Summary report. This report provides a summary of latch statistics, including misses and wait times, for a specified AWR snapshot interval.

  • Avatar photoCustomer

    I need to see if the contention spikes occurred at specific times of the day. Is there a report that breaks down latch activity chronologically?

  • Support Enginatics

    Yes, use the DBA AWR Latch by Time report. Each row in this report shows the system-wide latch contention wait time per latch name for one AWR snapshot interval, allowing you to identify high contention periods at specific times.

  • Avatar photoCustomer

    If the contention is specifically related to blocking sessions (e.g., buffer busy waits), which wait time metric in the SQL performance summary should I check?

  • Support Enginatics

    In the DBA AWR SQL Performance Summary report, examine the ‘Concurrency Wait Time’ column, which totals the elapsed time from wait event class ‘Concurrency’ like ‘buffer busy waits’.

  • You must be logged in to reply to this post.