> > Hi,
> >
> > After a lot of modifications to the database
> > (night batches), the tablespace RBS stay full
> > all the the batches are OK and committed ...
> >
> > Why the RBS is not emptied after all the transactions are committed ???
> >
> > Thanks in advance
> >
> > Oracle 8.1.7
> > AIX 4.3
>
> Those rbs blocks remain so that people can get read consistent views of
> the data (just in case their queries began before the large transactions
> commenced)
>
> They will be reused eventually
Ok, thanks
can I do:
alter rollback segment RSB01 shrink
Is it working ?
Received on Sat Sep 28 2002 - 04:11:07 CDT
