Re: RBS full

"zeb" <thierry.constant1_at_free.fr> wrote in message news:3d957276$1$10524$626a54ce_at_news.free.fr...
> > > 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 ?
>
>
>

Provided RSB01 is not a typo for RBS01: yes, of course.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address