library cache pin while trying to recreate a stored proc

From: dd yakkali <dd.yakkali_at_gmail.com>
Date: Wed, 26 Oct 2011 14:11:48 -0700
Message-ID: <CAJ-BTpw9JcLLsOfr=ra=DEd-dA+bLYRrY2z4YhNtNXs-UM1Vkg_at_mail.gmail.com>

11.1.0.7 on RHEL5
stored proc a is
begin
clone_x;
copy_x;
do_blah_x; <- Currently executing this.
....

end;

I am trying to recreate clone_x in a different session and i am is getting a library cache pin and it does not show any blocking session. I am wondering why i am even seeing AE type locks?

any help in understanding is greatly appreciated.

Thanks
Deen

SELECT * FROM GV$LOCK WHERE INST_ID=3 AND SID=2513;

   INST_ID ADDR             KADDR                   SID TY        ID1
ID2      LMODE    REQUEST      CTIME      BLOCK


---------- ---------------- ---------------- ---------- -- ----------

---------- ---------- ---------- ---------- ----------

         3 0000000906A7C5E8 0000000906A7C640       2513 AE
0          1          4          0       2411          2
         3 0000000906A8A8A8 0000000906A8A900       2513 AE
42769047          0          4          0       6895          2

select object_name,owner,object_type from dba_objects where object_id=42769047;
OBJECT_NAME

OWNER                     OBJECT_TYPE


--------------------------------------------------------------------------------------------------------------------------------

------------------------------ -------------------

ORA$BASE
SYS                       EDITION

SELECT SID, SERIAL#,BLOCKING_SESSION, BLOCKING_INSTANCE, PROGRAM, EVENT FROM GV$SESSION WHERE sid=2513 AND INST_ID=3;

 SID SERIAL# BLOCKING_SESSION BLOCKING_INSTANCE

PROGRAM                                          EVENT


---------- ---------- ---------------- -----------------

------------------------------------------------ -------

2513      24597
Toad.exe                                         library cache pin

--

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 26 2011 - 16:11:48 CDT