Monday, June 25, 2007

ora-01594

This is related to 8i database, which uses rollback segments.

01594, 00000, "attempt to wrap into rollback segment (%s) extent (%s) which is being freed"
// *Cause: Undo generated to free a rollback segment extent is attempting
// to write into the same extent due to small extents and/or too
// many extents to free
// *Action: The rollback segment shrinking will be rollbacked by the system;
// increase the optimal size of the rollback segment.

select * from dba_rollback_segs;
select * from v$rollstat;
--get the optimal size there

use below command to increase optimal size , if needs
alter rollback segment .. storage ( .. optimal );