library cache pin while trying to recreate a stored proc
- From: dd yakkali <dd.yakkali@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 26 Oct 2011 14:11:48 -0700
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
