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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:38

ORA-03170：在可读物理备用上死锁（undo段字符串）,
.原因：添加了新的还原段。查询可能偶尔发生死锁时，大约在添加并且立即在主数据库上使用undo段的时间。,
.操作：重试查询。避免在使用备用作为常规操作部分时创建新的还原段。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题