procedure在执行过程中出现的lock和pin

select KGLNAOBJ,KGLNAOWN,KGLHDPMD,KGLHDLMD from x$kglob where KGLHDPMD>0;

KGLNAOBJ                       KGLNAOWN   KGLHDPMD KGLHDLMD
------------------------------ ---------- -------- --------
select trim(parent_group_id)                     2        1
from dChnGroupInfo where group
_id=:b0 order by denorm_level
asc

PRC_TERM_SALEOUT               DBCHNADM          2        1
select KGLNAOBJ,KGLNAOWN,KGLHD                   2        1
PMD,KGLHDLMD from x$kglob

select KGLNAOBJ,KGLNAOWN,KGLHD                   2        1
PMD,KGLHDLMD from x$kglob wher

KGLNAOBJ                       KGLNAOWN   KGLHDPMD KGLHDLMD
------------------------------ ---------- -------- --------
e KGLHDPMD>0

UPDATE DCHNRESMOBINFO SET STAT                   2        1
US_CODE=:B9 ,SALE_PRICE=:B8 ,S
ALE_CODE=:B7 , USE_PHONE=:B6 ,
NOTE=:B5 ,OP_ACCEPT=:B4 ,OP_LO
GIN=:B3 , OP_TIME=SYSDATE,STAT
US_TIME=SYSDATE,OP_CODE=:B2 WH
ERE TRIM(IMEI_NO)=:B1

select * from dchnresmobinfo w                   2        1

KGLNAOBJ                       KGLNAOWN   KGLHDPMD KGLHDLMD
------------------------------ ---------- -------- --------
here group_id='10031' and stat
us_code='10'

BEGIN PRC_TERM_SALEOUT(:1,:2,:                   2        1
3,:4,:5,:6,:7,:8,:9,:10,:11);
END;

 KGLHDPMD 为pin mode为2共享Pin

KGLHDLMD为lock mode为1是null lock即是解析lock

select  * from v$lock中没有出现lock，可见procedure执行过程中只存在

library cache lock 1

library cache pin 2

所以，如果一个procedure在执行过程中是不能进行编译的，会出现library cache pin 等待。