Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: INITIAL and NEXT extent sizing question
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.
>