Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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.
Share information about yourself, create your own public profile at http://profiles.msn.com. Received on Mon Sep 25 2000 - 10:32:36 CDT
![]() |
![]() |