Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: about large and small rollback segments
Phil wrote:
>
> Hi,
>
> if disk storage is not a problem, can we make every rollback segment larger?
>
> is there a trad-off for large rollback segment?
>
> Thanks and have a nice day!
>
> Phil
If you make them larger be sure to use multiple smaller extents rather than one large extent if you have multiple transactions sharing rollback segments. I try to tune my rollback segments so that online transactions do not cause them to extend because this is expensive. I have large rollbacks and the main trade-off is backup time.
Big Al Received on Wed Aug 16 2000 - 16:52:08 CDT