ORA-01555

最新推荐文章于 2023-05-25 13:07:07 发布

转载最新推荐文章于 2023-05-25 13:07:07 发布 · 110 阅读

文章标签：

ORA-01555: snapshot too old: rollback segment number %s with name \\"%s\\" too small

The process which generated this error was in need for rollback/undo records to generate its consistent view.
At some point in time however, the data needed by your session (of which the undo records were written by another process) were marked as being free (a commit was done by that other session), and some other process already wrote other rollback/undo information to it.

If you're using manual UNDO Mode or use an Oracle version <9i, you can try to set a larger optimal size on the rollback segments.
You can issue following select to determine the current optimal size and the highwater mark size (maximum size ever reached since database startup).
:


select rb.segment_name, rs.optsize, rs.hwmsize
from v$rollstat rs, dba_rollback_segs rb
where rs.usn = rb.segment_id

To change the optimal size you can issue following select:


alter rollback segment rbs0 storage (optimal 100m);

Pay attention that the size you specify for optimal will be constantly allocated inside the tablepace.
If you are using automatic UNDO mode, you can try to increase the value of undo_retention.