DBPedias

All your database knowledge are belong to you

Oracle

Wait Events - undo retention publish retry

undo_retention publish retry

This wait can occur for two reasons. A session issuing an ALTER SYSTEM SET UNDO_RETENTION may wait on this event wait while a cluster reconfiguration takes place. Or, the background process MMNL may wait for cluster reconfiguration while attempting to determine the max UNDO_RETENTION. Wait time:

1 second

Parameter

Description

P1

Identifies where the retry is happening. Id = 1 retry while publishing into the max undo_retention namespace. Id = 2 retry while iterator accessing the max undo_retention namespace.

P2

Retry count (maximum number of retries is 5)