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 problem

Re: RBS problem

From: Tom Best <tom.best_at_bentley.com>
Date: 2000/07/14
Message-ID: <8kn4fi$dtr$1@news.bentley.com>#1/1

Yes, optimal will solve this. Use

ALTER ROLLBACK SEGMENT <rbsname> OPTIMAL 50M

to tell Oracle to, during normal operations, attempt to deallocate unused extents until it gets back to 50 meg.

Use:

ALTER ROLLBACK SEGEMENT <rbsname> SHRINK

to attempt to shrink it down right now, to the optimal size.

HTH.
Tom Best

<dlane_at_cix.compulink.co.uk> wrote in message news:8klhbc$1cf$1_at_plutonium.compulink.co.uk...
> Did you set 'optimal' in the storage clause when you created the rollback
> segments?
>
>
> Dave Lane (dlane_at_pt.lu)
>
>
> In article <8kjush$5lj$1_at_nnrp2.deja.com>, tigsar_at_my-deja.com () wrote:
>
> > Can anybody say me
> >
> > Why the rollback tablespace is enlarging;
> > Default size of rbs (when installing) was 50Mb, now it 580Mb
> >
> > Thanks
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Fri Jul 14 2000 - 00:00:00 CDT

Original text of this message

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