RE: INITIAL and NEXT extent sizing question

Apparently I phrased my initial question(s) incorrectly...

I have a table that has a core set of essentially read-only records (very very few updates/deletes.) For application reasons, new inserts must occur in this same table. (Creating one readonly table for the old records and one new table for the new inserts is not possible in our situation.) I wish to export all of the data in the table and re-import it in an organized fashion. What is my best solution?

1. Should I create one large initial extent for all of the data already in there? (To do this do I just multiply the block_size by (Select BLOCKS from dba_tables) after analyzing of course??
2. Then, how do I go about picking the correct size for my NEXT extent?

Thank you ,

   -Fred S.

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.
   

>From: Jared Still <jkstill_at_bcbso.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: INITIAL and NEXT extent sizing question
>Date: Wed, 27 Sep 2000 06:41:26 -0800
>
>
>That's an urban myth.
>
>The only performance drawback to a large number ( >1024 ) of extents
>is data dictionary management. With LMT's ( locally managed tablespaces)
>there is little point in worrying over the number of extents.
>
>DBA's have more important things to do. :)
>
>Jared
>
>On Wed, 27 Sep 2000 Deepender_Gupta_at_escorts.co.in wrote:
>
> >
> > But Oracle says that we try to have our table in not more than 5
>extents.
> > What is the advantage of having more extents of smaller size as opposed
>to
> > having 1 big
> > extent.
> >
> > Kindly elaborate.
> > Deepender
> >
> >
> >
> >
> >
> > To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>@SMTP_at_AMG1
> > cc:
> >
> > Hi
> >
> > It would all depend on the table. If the table is not going to grow
> > then the NEXT should be set low (Hence the table would not extend).
> > If the table would be continually growing then the NEXT should be
> > sized accordingly to allow for inserts.
> > Try not to make the NEXT too big (>1GB)
> > eg. You rather have 4 * 500M extents as opposed to having 1 * 4GB
> > extent.
> >
> > HTH
> > Suhen
> >
> > >>> Venkat_Kalepalli_at_satyam.com 09/26/00 02:51PM >>>
> > I think U can set NEXT also same as INITIAL.
> >
> >
> > Venkat
> > Ph:7846101- Extn: 5648
> >
> > > ----------
> > > From: Fred Smith[SMTP:fred_fred_1_at_hotmail.com]
> > > Reply To: ORACLE-L_at_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_at_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_at_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).
> > >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Suhen Pather
> > INET: PatherS5_at_telkom.co.za
> >
> > 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
> > 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: Deepender_Gupta_at_escorts.co.in
> >
> > 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
> > 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).
> >
>
>
>Jared Still
>Certified Oracle DBA and Part Time Perl Evangelist ;-)
>Regence BlueCross BlueShield of Oregon
>jkstill_at_bcbso.com - Work - preferred address
>jkstill_at_teleport.com - private
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jared Still
> INET: jkstill_at_bcbso.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
>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).