解决enq: TX，解决enqtx
解决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
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。