Library cache lock and library cache pin waits

November 9, 2012 at 3:23 pm | Posted in Oracle Developement | Leave a comment

Reblogged from Oracle database internals by Riyaj:

I encountered few customer issues centered around library cache lock and library cache pin waits. Library cache lock and pin waits can hang instance, and in few cases, whole clusters of RAC instances can be hung due to library cache lock and pin waits.

Why Library cache locks are needed?

Library cache locks aka parse locks are needed to maintain dependency mechanism between objects and their dependent objects like SQL etc.

Read more… 1,870 more words

I came accross 100% library cache pin waits, while trying to compile a procedure which was currently executing. After a little research, I came across this fantastic article by Riyaj Shamsudeen.