Database Appears to Hang Waits for "Wait for a undo record" and "Wait for stopper event to be increased" Due to Parallel Transaction Recover
(Doc ID 464246.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
- Database appears to hang
- Undo tablespace is growing.
- Systemstate dump shows the significant waits are for "Wait for a undo record" and "Wait for stopper event to be increased".
The systemstate dump shows the following waitevents:
and in this second section the process in question has been waiting for 'wait for a undo record' event for 243 seconds.
The wait events "Wait for a undo record" and "Wait for stopper event to be increased" are mainly meant for parallel transaction recovery.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!