Re: Creating a 'library cache pin' wait for testing.

If you want to simulate a wait, you need some other session to try to do something with your procedure (while it is running):

Session 12:
exec dummy1;dbms_lock.sleep(60)
...sleeps for 60 seconds...

Session 13:
alter procedure dummy1 compile;
...should hang while 12 is sleeping

select sid,event from v$session_wait where sid in (12,13);

       SID EVENT

        13 library cache pin
        12 PL/SQL lock timer