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, the rest of the block is used for rollback change vectors.
--- [EMAIL PROTECTED] wrote: > While on the subject.. > Please see the Oracle Metalink Note: 1029850.6. > It says the first "block" of the first segment contains header > information. > > > > -----Original Message----- > > From: Kumanan Balasundaram > > Sent: 15 March 2002 17:59 > > To: '[EMAIL PROTECTED]' > > 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 > > > > -----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 as the segment header to manage > > the > > transaction information within the rollback segment. The second > > extent > > contains the actual change vectors > > > > > > --- [EMAIL PROTECTED] wrote: > > > Hi, > > > > > > 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:[EMAIL PROTECTED]] > > > > Sent: 07 March 2002 20:54 > > > > To: Multiple recipients of list ORACLE-L > > > > Subject: 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. > > > > > > > > > > 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: [EMAIL PROTECTED] > > > > > > > > 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and > > in > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > (or the name of mailing list you want to be removed from). > You > > may > > > > also send the HELP command for other information (like > > > subscribing). > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: > > > INET: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and > > in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You > > may > > > also send the HELP command for other information (like > > subscribing). > > > > > > __________________________________________________ > > Do You Yahoo!? > > Try FREE Yahoo! Mail - the world's greatest free email! > > http://mail.yahoo.com/ > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rachel Carmichael > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and > in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You > may > > also send the HELP command for other information (like subscribing). __________________________________________________ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
