Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RBS full

Re: RBS full

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 28 Sep 2002 14:12:47 +0200
Message-ID: <upb7oeqlfn13bb@corp.supernews.com>

"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
Received on Sat Sep 28 2002 - 07:12:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US