Database Tuning (MOSC)

MOSC Banner

Discussions

"Wait for a undo record" and "Wait for stopper event to be increased"

edited Sep 6, 2018 12:05PM in Database Tuning (MOSC) 2 commentsAnswered

Hello everyone,

I´ve received a lot of events the "Wait for a undo record" and "Wait for stopper event to be increased" in my Oracle Database 11.2.0.3

As follow the Note ID 464246.1, those events happen because my fast_start_parallel_rollback is set to 'LOW', and therefore the background process SMON acts as a coordinator and rolls back a set of transactions in parallel using multiple server processes.

The solution to this issue is set the parameter to false, but I don´t want to change the parameter, because first of all, I need to understand and I need how to find out how much rollback a session has to do and which transactions of rollback were running.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center