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: about large and small rollback segments

Re: about large and small rollback segments

From: Big Al <db-guru_at_att.net>
Date: Wed, 16 Aug 2000 21:52:08 GMT
Message-ID: <399B0CB5.3767961E@att.net>

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

Original text of this message

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