My point was that it could allocate one more extent as per need. Why the
need to minextents = 2?
Thanks
Kumanan
> -----Original Message-----
> From: Stephane Faroult [SMTP:sfaroult_at_oriole.com]
> Sent: 07 March 2002 20:54
> To: Multiple recipients of list ORACLE-L
> Subject: Re: A rollback segment question on minextents
>
> kumanan.balasundaram_at_qxl.com wrote:
> >
> > Hi,
> >
> > I was wondering why Oracle force minextents for rollback
> > segments to be two. Why can't we have minextents zero or
> > no minextents clause at all.
> >
> > We can surely set initial extent to be large enough ourselves
> > and next extent sized accordingly.
> >
> > Can someone enlighten me on the reason/thought behind this?
> >
> > Many thanks
> >
> > Kumanan Balasundaram
> > Database Administrator, IT
> > QXL ricardo plc
> > www.qxl.com
> > P: +44 (0)208 962 7409
>
> Oracle doesn't reuse an extent which contains active transactions. What
> do you think would happen when you reach the end of your initial extent
> ? Exactly.
> --
> Regards,
>
> Stephane Faroult
> Oriole Ltd
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Stephane Faroult
> INET: sfaroult_at_oriole.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
