15 March 2002 20:59
> To: Multiple recipients of list ORACLE-L
> Subject: RE: A rollback segment question on minextents
>
> yes, Jonathan Lewis was kind enough to correct me privately on this.
>
> It is indeed only the first block that's used for header information,
> >
> > Kumanan
> >
> > -Original Message-
> > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
> > Sent: 11 March 2002 21:48
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: A rollback segment question
gt;
> > -Original Message-
> > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
> > Sent: 11 March 2002 21:48
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: A rollback segment question on minextents
> >
> >
pond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: A rollback segment question on minextents
Actually the rollback segment header in the first extent exists in a
single
block, the rest of the first extent,
asted? Sure not!
Kumanan
> -Original Message-
> From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
> Sent: 11 March 2002 21:48
> To: Multiple recipients of list ORACLE-L
> Subject: RE: A rollback segment question on minextents
>
> the first extent is used by oracle
'
> Cc: '[EMAIL PROTECTED]'
> Subject: RE: A rollback segment question on minextents
>
> Oracle recommends the size NEXT=INITIAL.
> So if I had 10M initial, then most of the initial beyond the
> header info will be wasted? Sure not!
>
> Kumanan
>
>
ents of list ORACLE-L
> Subject: RE: A rollback segment question on minextents
>
> the first extent is used by oracle as the segment header to manage the
> transaction information within the rollback segment. The second extent
> contains the actual change vectors
>
>
>
Why
> the
> need to minextents = 2?
>
> Thanks
> Kumanan
>
> > -Original Message-
> > From: Stephane Faroult [SMTP:[EMAIL PROTECTED]]
> > Sent: 07 March 2002 20:54
> > To: Multiple recipients of list ORACLE-L
> > Subject:Re:
ect: Re: A rollback segment question on minextents
>
> [EMAIL PROTECTED] 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
[EMAIL PROTECTED] 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
10 matches
Mail list logo
