DML DML DML TM
P1=|模式名称
P2=对象#
P3=表/分区
完成选择,名称、parameter1 parameter2, parameter3从v $ event_name名字像& # 39;询问:,TM -争用# 39;;
NAME ,,,,,,,,,,,,,,,,,,,,,,,,,PARAMETER1 ,,,,,,,,,PARAMETER2 ,,,,,,,,,PARAMETER3
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -,- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
询问:TM - contention ,,,,,,,,,名字| mode ,,,,,,,,,,对象#,,,,,,,,,,,,表/分区
,
sql 拦截器
选择不同的w。tm, w。p2 OBJECT_ID,,linst_id, l。席德,l。lmode、l.request l.block
从,
,(,选择p2、p3 & # 39; TM & # 39; | | substr (p2raw 8) | | & # 39; & # 39; | | lpad (p3 8 & # 39; 0 & # 39;)TM
,,,,,,从v $ session_wait
,,,,,事件=& # 39;询问:TM -争用# 39;
,,,,,,,和国家=& # 39;等待# 39;
,),W
,,问美元锁定L
,在l.type (+)=& # 39; tm # 39;
,,,和l.id1 (+)=w.p2
,,,和l.id2 (+)=w.p3
,以tm, lmode desc,请求desc
;
TM
DDL
锁表tab_name共享模式;锁表tab_name独占模式
/* +附加*/插入
SQL *加载程序 直接路径负载
询问:TM -争用
1
SYS@cdbtest1(国开行根美元)比;锁表t,在独占模式;
表锁(s) .
2
SYS@cdbtest1(国开行根美元)比;更新t组,object_id=100, object_id=100;
SYS@cdbtest1(国开行根美元)在,,,,选择inst_id、事件#活动,count (*),从会话
美元全球之声,,2,,,,,,在wait_class #,& lt;比;6
,,3,,,,,集团通过inst_id,,事件#、事件
,,4,,,,,订单1、4 desc;
,,,INST_ID ,,,事件# EVENT ,,,,,,,,,,,,,,,,,,,,,,,,,,COUNT (*)
- - - - - - - - - - - - - - - - - - - - - -,- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
,,,,,,,,,1,,,,,,,278询问:TM -,contention ,,,,,,,,,,,,,,,,,,1
,,,,,,,,,1,,,,,,,414 SQL *网消息,client ,,,,,,,,,,,,,1
拦截器
选择不同的w。tm, w。p2 OBJECT_ID,,linst_id, l。席德,l。lmode l.request, l。blocklmode、l.request l.block
从,
,,2,,,3,,,(选择p2、p3,& # 39;TM & # 39; | | substr (p2raw 8) | | & # 39; & # 39; | | lpad (p3 8 & # 39; 0 & # 39;)TM
,,4,,,,,,,从v $ session_wait
,,5,,,,,,事件=& # 39;询问:TM -,争用# 39;
,,6,,,,,,,,和国家=& # 39;等待# 39;
,,7,,,)W
,,8日,,,问美元锁定L
,,9,,在l.type (+)=& # 39; tm # 39;
, 10个,,,,,和l.id1 (+)=w.p2
, 11,,,,,和l.id2 (+)=w.p3
, 12,,,订单由tm、lmode desc请求desc
, 13,
;TM ,,,,,,,,,,,,,,,,,,OBJECT_ID ,,INST_ID ,,,,,,SID ,,,,LMODE ,,,REQUEST ,,,,块
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -,- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
tm - 00013866 - 00013866,,,,,79974,,,,,,,,,1,,,,,,,113,,,,,,,,,6,,,,,,,,,0,,,,,,,,,1
tm - 00013866 - 00013866,,,,,null null null null