Message-Id: <10631.117856@fatcity.com> From: Venkat_Kalepalli Date: Tue, 26 Sep 2000 17:10:16 +0530 Subject: RE: INITIAL and NEXT extent sizing question This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C027AF.35306800 Content-Type: text/plain I think U can set NEXT also same as INITIAL. Venkat Ph:7846101- Extn: 5648 > ---------- > From: Fred Smith[SMTP:fred_fred_1@hotmail.com] > Reply To: ORACLE-L@fatcity.com > Sent: Monday, September 25, 2000 10:05 PM > To: Multiple recipients of list ORACLE-L > Subject: INITIAL and NEXT extent sizing question > > I have a table with rows currently populating. I wish to resize the table > > for better performance. What is the best way I should figure out how to > size my INITIAL and NEXT extent sizes for this table. Is it just: > 1) Analyze the table > 2) SELECT BLOCKS * (block_size) from dba_tables for the table in question > = > what the initial size should be set to. > 3) What determines what I should set the NEXT extent size to then? > > Thank you, > -Fred S. > _________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > Share information about yourself, create your own public profile at > http://profiles.msn.com. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Fred Smith > INET: fred_fred_1@hotmail.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@fatcity.com (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). > ------_=_NextPart_001_01C027AF.35306800 Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: INITIAL and NEXT extent sizing question

I think  U can = set NEXT also same as INITIAL.


Venkat
Ph:7846101- = Extn: 5648