‘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


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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s