Troubleshooting Oracle 19c hang wait ‘enq: TX – contention’ when RECO distributed Transaction recovery

  • 2023/05/13
  • ORACLE 9i-23ai
  • 290 views
  • Troubleshooting Oracle 19c hang wait ‘enq: TX – contention’ when RECO distributed Transaction recovery已关闭评论

Oracle 19c RAC实例大量会话hang,等待事件为’enq: TX – contention’， 做hanganalyze 堵塞进程为RECO， ‘buffer busy waits’<='enq: TX - contention' (cycle) RECO与前台进程形成死锁， 分布式事务表dba_2pc_pendings无记录。简单记录处理过程.

, ,

阅读全文