RE: INITIAL and NEXT extent sizing question

It is my understanding that NEXT being set to the same value of INITIAL is
good idea in terms of keep fragmentation of tablespaces to a minimum. This
is also assuming that you keep the extent sizes of other tables in the
tablespace to that same extent size. This then means that should a table be
dropped for any reason, those extents can easily be reused by another table
wanting to extend.

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?

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).
Received on Tue Sep 26 2000 - 08:09:03 CDT