| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: INITIAL and NEXT extent sizing question
Fred
U cann't change initial. Well ! if U are prepared to export and import it.
Next U can change. Initial and Next to be of same size is controversial.
Resizing of table U can do it with alter table cmd.
Rao
-- On Tue, 26 Sep 2000 06:10:56 Mark Leith wrote:Received on Wed Sep 27 2000 - 00:33:28 CDT
>Fred,
>
>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.
>
>
>
>-----Original Message-----
>Sent: 25 September 2000 17:36
>To: Multiple recipients of list ORACLE-L
>
>
>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: Mark Leith
> INET: mark_at_cool-tools.co.uk
>
>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).
>
Get your FREE Email and Voicemail at Lycos Communications at
 |
 |