One of the best sites for scripts related to checking library cache locks… http://allappsdba.blogspot.qa/2012/04/to-check-library-cache-lock-contention.html
Tag Lock
Oracle Locking Mechanism Probably the best article out their explaining Oracle’s locking mechanism. Oracle Guru Arup Nanda explains the mystical…