<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>
下午,业务人员报告,执行任何和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>