Library cache lock and library cache pin waitsNovember 9, 2012 at 3:23 pm | Posted in Oracle Developement | Leave a comment
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.