首页 > 其他 > 详细

解决enq: TX - index contention的常用方法

时间:2015-05-23 00:03:20      阅读:411      评论:0      收藏:0      [点我收藏+]

解决enq: TX - index contention的常用方法

摘自:
Troubleshooting ‘enq: TX - index contention‘ Waits (Doc ID 873243.1)

o  Rebuild the index  as reverse key indexes or hash partition the indexes which are listed in the ‘Segments by Row Lock Waits‘ of the AWR reports

o  Consider increasing the CACHE size of the sequences

o  Rebuild or shrink associated index after huge amount of data purge

o  Increase PCT_FREE for the index

解决enq: TX - index contention的常用方法

原文:http://blog.csdn.net/msdnchina/article/details/45922621

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!