librarycachelock的解决案例

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

 下午，业务人员报告，执行任何和zzss03201281cs_no表有关的操作都会hang住，包括desczzss03201281cs_no，也会hang在那里

第一感觉是锁了，于是，我看看锁

SQL>select*fromv$lockwhereblock=1;

norowsselected

SQL>
SQL>select*fromgv$lockwhereblock=1;

norowsselected

SQL>

 

再看看等待事件：

SQL>coleventfora30
SQL>l
 1*selectevent,p1,p2,sidfromv$session_waitwhereevent='librarycachelock'
SQL>/

EVENT                                 P1        P2       SID
------------------------------------------------------------
librarycachelock            1.3835E+191.3835E+19        32

SQL>/

EVENT                                 P1        P2       SID
------------------------------------------------------------
librarycachelock            1.3835E+191.3835E+19        32

SQL>/

EVENT                                 P1        P2       SID
------------------------------------------------------------
librarycachelock            1.3835E+191.3835E+19        32

。。。

 

奇怪，怎么这么多librarycachelock ？

SQL>showuser
USERis"SYS"
SQL>execdbms_system.set_ev(32,27506,10046,12,'');

PL/SQLproceduresuccessfullycompleted.

Elapsed:00:00:00.10
SQL>l
 1 SELECT   d.VALUE
 2        ||'/'
 3        ||LOWER(RTRIM(i.INSTANCE,CHR(0)))
 4        ||'_ora_'
 5        ||p.spid
 6        ||'.trc'trace_file_name
 7   FROM(SELECTp.spid
 8           FROMv$mystatm,v$sessions,v$processp
 9          WHEREm.statistic#=1ANDs.SID=m.SIDANDp.addr=s.paddr)p,
 10        (SELECTt.INSTANCE 1 <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>