librarycachelock的解决案例

<script type="text/javascript"><!-- google_ad_client = "pub-2947489232296736"; /* 728x15, 创建于 08-4-23MSDN */ google_ad_slot = "3624277373"; google_ad_width = 728; google_ad_height = 15; //--> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript"><!-- google_ad_client = "pub-2947489232296736"; /* 160x600, 创建于 08-4-23MSDN */ google_ad_slot = "4367022601"; google_ad_width = 160; google_ad_height = 600; //--> </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.INSTANCE1 <script type="text/javascript"><!-- google_ad_client = "pub-2947489232296736"; /* 728x15, 创建于 08-4-23MSDN */ google_ad_slot = "3624277373"; google_ad_width = 728; google_ad_height = 15; //--> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript"><!-- google_ad_client = "pub-2947489232296736"; /* 160x600, 创建于 08-4-23MSDN */ google_ad_slot = "4367022601"; google_ad_width = 160; google_ad_height = 600; //--> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
阅读更多
文章标签: session file
个人分类: 数据库
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭