A production database of showed 4 cores of CPU burning constantly by 2 process E000 and E001. On further investigation…
Tag wait
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
The “Library Cache Pin” wait event is generally a wait event associated with library cache concurrency. Generally the wait event…