Troubleshooting many session waiting ‘latch free'(transaction branch allocation) 11gR2

  • 2018/11/29
  • ORACLE 9i-23ai
  • 829 views
  • Troubleshooting many session waiting ‘latch free'(transaction branch allocation) 11gR2已关闭评论

前日有套11.2.0.3 RAC on HPUX数据库环境突然出现较高的latch: free wait event, 该event在10G以后的版本较为少见（已经细化为具体latch） , 通过p1 or p2值可以确认具体latch. transaction branch allocation占用较高的db time

,

阅读全文