Latches are Oracle internal locking mechanisms. They prevent multiple sessions from simultaneously updating the same item within Oracle shared memory (SGA). If a session needs to acquire a latch that is held by another session, a latch free wait may occur.
The presence of latch free waits of any significant magnitude may indicate a bottleneck within the SGA. The specific action depends on the latch. Relieve Latch Contention
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center