Hi
database version is 11.2.0.4
big inserts worked fine for many years. Since few days we started getting ORA-01628
undo_management is AUTO
undo_retention _highthreshold_undoretention lowered which resumed suspended session but only for few minutes before reaching again max
UNDO recreated many times and it didn't help.
every time old UNDO cannot be dropped even after restart. after forcing rollback segments offline in spfile this led to corruption of indexes. Inserts then hang without any error.
is it an idea to put undo_management to MANUAL ? so may be
alter rollback segment "..." storage (MAXEXTENTs unlimited);
will work