My Oracle Support Banner

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 to [Release 12.1]
Oracle Database - Enterprise Edition - Version to [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 

EventWaitsTime(s)Avg wait (ms) % DB timeWait Class
latch free 1,237,131 128,011 103 31.44 Other 

Most of latch waits are for "transaction branch allocation" i.e. 121,162 seconds 

Latch NameGet RequestsPct Get Miss Avg Slps /MissWait 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 NameWhereNoWait Misses SleepsWaiter 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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.