Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: RBS problem
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