ORA-03170: deadlocked on readable physical standby (undo segment string)

ORA-03170: deadlocked on readable physical standby (undo segment string)


Cause:


A new undo segment was added. A query can occasionally deadlock when issued around the time an undo segment is added and used immediately on the primary.



Action:


Retry the query. Avoid creating new undo segments when using standby as a regular part of operation.