Re: Rollback segment - ORA-01581

From: <mark.powell_at_eds.com>
Date: Tue, 19 Jan 1999 14:20:20 GMT
Message-ID: <7824ar$ut2$1@nnrp1.dejanews.com>

Gerald,
First from Oracle

// *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.

I would think your real underlying problem is your database needs more than
two rollback segments allocated to it.	Also, do you really want to allow a

single transaction to generate as much rollback as you have set in your maxextents? -- Mark D. Powell --

In article <DQZo2.292$12.37818_at_news.tpnet.pl>,   "Gerard Szyja" <gszyja_at_compass.pl> wrote:
> We are running Oracle 8.0.4 on Windows NT.
> Tablespace for rollback segment - 300 M and AUTOEXTEND ON
> (3 GB free space on HDD)
>
> 2 identical rollback segments (online) :
> initial 5 M
> next 5 M
> optimal 25 M
> min 5
> max 2147483645
>
> For large transaction rollback segment
> extend to 80M - 120M and generate ORA-01581 error.
>
> What is the reason for this error ?
>
> Thanks in advance
> Gerard
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Jan 19 1999 - 08:20:20 CST