重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-01554 Reason: No Undo Segment Found With Available Slot [打印本页]

作者: jiawang 时间: 2019-6-27 13:41
标题: ORA-01554 Reason: No Undo Segment Found With Available Slot
本帖最后由 jiawang 于 2019-7-1 09:16 编辑

报错现象：

Thu May 23 15:01:46 2019

[26475] ORA-01554 reason: no undo segment found withavailable slot

Thu May 23 15:01:46 2019

[31144] ORA-01554 reason: no undo segment found withavailable slot

Thu May 23 15:01:47 2019

[31156] ORA-01554 reason: no undo segment found withavailable slot

Thu May 23 15:01:47 2019

[26496] ORA-01554 reason: no undo segment found withavailable slot

Thu May 23 15:01:47 2019

[26536] ORA-01554 reason:no undo segment found with available slot

APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.
SYMPTOMS

Below error message reported in the alert log file.

ORA-01554 reason: no undo segment found with available slot

CHANGES
CAUSE

_rollback_segment_count is set to 0 incorrectly

SOLUTION

Set using below command minimum "_rollback_segment_count"=100 and monitor the ORA-1554 error in alert log file.

SQL> alter system set "_rollback_segment_count"=100;

REFERENCESNOTE:1579035.1 - Script - Check Current Undo Configuration and Advise Recommended Setup

参考：metalink ID2452558.1

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)