Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Creating a 'library cache pin' wait for testing.

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

From: <krichine_at_juno.com>
Date: 19 Mar 2006 11:03:18 -0800
Message-ID: <1142794998.877698.39770@i40g2000cwc.googlegroups.com>


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
Received on Sun Mar 19 2006 - 13:03:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US