Database Hangs When Non-default Value Set to _SPIN_COUNT in 12.2 and Onward
(Doc ID 2642260.1)
Last updated on MAY 07, 2020
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
- Startup/Shutdown hangs
- DB hangs with latch contention and sessions waiting on 'wait list latch free':
Chains most likely to have caused the hang:
[a] Chain 1 Signature: 'wait list latch free' ►►
Chain 1 Signature Hash: 0x18c0e2
[b] Chain 2 Signature: 'wait list latch free'
Chain 2 Signature Hash: 0x18c0e2
[c] Chain 3 Signature: 'wait list latch free'
Upgrade to 18c or 19c from a Lower version where the non-default value of _spin_count is already set.
Change _spin_count to a non-default value in 18c or 19c.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document