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.
- Neat little comment trick.
- To Flash or Not To Flash: Apex 4.2 answers the question.