Latch Free Event

What is Latch Free Event? When will you encounter this type of event? How will you solve it?

Questions by krishnaprasad.sola   answers by krishnaprasad.sola

Showing Answers 1 - 9 of 9 Answers

patkar_akanksha

  • Jun 11th, 2009
 

The latch free Oracle metric occurs when the process is waiting for a latch held by another process (this wait event does not apply to processes that are spinning while waiting for a latch; when a process is spinning, it is not waiting).

If you experience waits on latch free, enqueue, LGWR waits, or buffer busy waits, you need to locate the cause of the contention.

  Was this answer useful?  Yes

himanshi11

  • Mar 15th, 2011
 

Latch is basically an electronic circuitory that holds the state of a system. It stores only a single bit inforamtion at a time.

  Was this answer useful?  Yes

Nishanth

  • Mar 14th, 2016
 

The Oracle latch free wait event occurs when a session needs a latch, tries to get the latch, but fails because someone else has it. So, it sleeps with a wait on latch free, wakes up and tries again. The time it was asleep is the wait time for "latch free". There is no ordered queue for the waiters on a latch so the first to grab the latch gets it.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions