Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do you shrink rollback segments?
Hi,
All you have to do is:
ALTER ROLLBACK SEGMENT <segment_name> SHRINK;
This will result in the rollback segment being shrunk to its OPTIMAL size every time Oracle no longer requires any additional space occupied by the rollback segment.
Regards
Jerry
aa wrote:
>
> I know when you shrink the rollback segment after all transactions are
> committed, it will reduce back to the defined optimum size. My question is:
> is this the only way to reduce it back to the optimum? Or is there some
> parameter that I can set so that it will shrink itself automatically after
> some time?
-- Jerry Gitomer Since I know how to spell DBA I became one. jgitomer_at_p3.netReceived on Sat Feb 28 1998 - 00:00:00 CST