Thousands of active sessions waiting on latch free in relation to 'transaction branch allocation'
Last updated on FEBRUARY 06, 2018
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
Symptoms
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 |
|---|---|---|---|---|---|
| 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 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 |
Cause
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 hundreds of Community platforms