‘Latch Free’ Wait Event

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.

Possible causes of ‘Latch Free’ wait.

– If its due to Shared pool or Library cache latching, then the problem is due to excessive hard-parsing. (Most likely because of lack of bind variables)

– Another possible cause may be due to ‘cache buffer chains latching’.

Reference : https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=454764592204737&id=34576.1&_afrWindowMode=0&_adf.ctrl-state=xsq7uenau_62
http://www.toadworld.com/platforms/oracle/w/wiki/1296.resolving-the-latch-free-wait.aspx
http://logicalread.solarwinds.com/oracle-latch-free-wait-dr01/#.VQFzzvmUd8E
http://oracletechdba.blogspot.sg/2014/08/wait-event-latch-free-waits.html
https://andreynikolaev.wordpress.com/2010/12/16/hidden-latch-wait-revolution-that-we-missed/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s