Friday, 26 February 2016

Latch Free Waits

Possible Causes:

  •         This wait indicates that the process is waiting for a latch that is currently busy (held by another process).
  •         When you see a latch free wait event in the V$SESSION_WAIT view, it means the process failed to obtain the latch in the willing-to-wait mode after spinning _SPIN_COUNT times and went to sleep. When processes compete heavily for latches, they will also consume more CPU resources because of spinning. The result is a higher response time.

Actions:

·        If the TIME spent waiting for latches is significant then it is best to determine which latches are suffering from contention.

Remarks:

No comments: