Thousands of active sessions waiting on latch free in relation to 'transaction branch allocation'
(Doc ID 2018260.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 12.1]
Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 11.2]
Information in this document applies to any platform.
Experiencing contention for "transaction branch allocation" latch with a large fraction of the requests from location kpupuc.
A large number of active sessions are waiting for latch free as per the AWR report which shows
|Event||Waits||Time(s)||Avg wait (ms)||% DB time||Wait Class|
Most of latch waits are for "transaction branch allocation" i.e. 121,162 seconds
|Latch Name||Get Requests||Pct Get Miss||Avg Slps /Miss||Wait Time (s)||NoWait Requests|
|transaction branch allocation||112,307,430||15.11||0.07||121162||0|
AWR report shows the highest number of waits/sleeps are occurring in function ksupuc followed by functions ktcsbr and ktcbba as per the following section
|Latch Name||Where||NoWait Misses||Sleeps||Waiter Sleeps|
|transaction branch allocation||ksupuc||0||811,508||891,320|
|transaction branch allocation||ktcsbr||0||128,862||82,780|
|transaction branch allocation||ktcbba||0||84,239||143,093|
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!