Segments by Row Lock Waits
来源:互联网 发布:php 自定义模版引擎 编辑:程序博客网 时间:2024/06/08 11:53
SQL> select OWNER,INDEX_NAME,TABLE_NAME from DBA_indexes where INDEX_NAME='F_AGT_BUSS_DUEB_END_DT';
OWNER INDEX_NAME TABLE_NAME
------------------------------ ------------------------------ ------------------------------
DWF F_AGT_BUSS_DUEB_END_DT F_AGT_BUSINESS_DUEBILL_H
enq TX - index contention
这个等待事件表示发生了索引等待,如果该等待事件排名靠前,可以查看 AWR 中的 Segments by Row Lock Waits 里面的 index row lock waits 条目
根据 Segments by Row Lock Waits 中的索引名字,查看索引是否是 unique index
1.如果是unique index,很有可能是2个或者多个session同时insert相同的索引条目,就会引发 enq TX - index contention
2.索引block分裂 ,下面是索引分裂产生 enq TX - index contention 的实验
0 0
- Segments by Row Lock Waits
- awr中的Segments by Row Lock Waits模拟
- Segments by ITL Waits 问题及解决
- Segments by ITL Waits 问题及解决
- Segments by ITL Waits 问题及解决
- row lock waits的两种情况
- 模拟等待事件row lock waits
- Troubleshooting ‘DFS lock handle’ waits
- 'library cache lock' Waits: Causes and Solutions
- row cache lock
- row cache lock事件
- 模拟row cache lock
- HBase1.1.2 row lock
- ???Line Segments Clipped by Windows
- enq: TX - row lock contention
- enq: TX - Row Lock Contention
- enq: TX - row lock contention
- Row Exclusive Table Lock (RX)
- HDU2545:树上战争
- 动态判断文字大小,动态排版
- 线段树--Color the ball(多次染色问题)
- python 视频处理,提取视频相关帧,读取Excel
- C#利用vbs控制3D Stereoscopic Player播放器
- Segments by Row Lock Waits
- 重新认识HTML,CSS,Javascript 之node-webkit 初探
- poj2411 Mondriaan's Dream
- JavaScript数值转换总结
- touch
- pat1015_错题备份
- 理解RESTful架构
- 博弈知识汇总
- LVM2 Logical Volume Manager 详解(六)--LVM物理卷Physical Volume命令实战