Oracle DBA, How To, Error, Cause and Action

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.