Re: Rollback Segments

This is what I found out about ORA-1581. How big is your rollback tablespace?

Error: ORA 1581
Text: attempt to use rollback segment (%s) new extent (%s) which is being allo

        cated

---
Cause:  Undo generated to extend a rollback segment run out of current
        undo block space and is attempting to write into the new extent
        which has not been completely allocated.
Action: The rollback segment extending will be rollbacked by the system,
        no more extension will be possible untill the next extent is
        freed up by rolling back or committing other transactions.



"Andreas Boehm" <andreas.boehm_at_class.de> wrote in message
news:39E497AE.ED9C9779_at_class.de...


> Hi all,

>

> currently I am getting the following messages:

>   ERROR at line 1:

>   ORA-01562: failed to extend rollback segment number 8

>   ORA-00604: error occurred at recursive SQL level 1

>   ORA-01581: attempt to use rollback segment (8) new extent (15) which

> is being allocated

> I get them in a transaction which updates some rows in a table

> containing abou 30*10*9 rows.

> The alert log tells the following:

>   Failure to extend rollback segment 8 because of 1581 condition

>   FULL status of rollback segment 8 set.

>

> How do I prevent this occurance? The docs don't tell anything about this

> messages.

>

> I tried to increase the optimal, but this doesn't change anything.

>

> The rollback segments are configured as follows:

>   10 rollback segments

> for each of them

>    tablespace RBS

>    optimal 75M

>    next 2M

>    maxextents unlimited

> dba_free_space tells me about 400M free in tablespace RBS

>

> please help.

>

> regards,

> Andreas Boehm

>

>