transaction branch allocation

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

2018-12-222018-11-29 by weejar zhang

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