library cache pin while trying to recreate a stored proc

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


Other related posts: