First of all if your database is version 8.1+ why aren't you using locally managed tablespaces? The proper setting of storage clause parameters depends on your tablespace management policies. Under dictionary management you want to use a limited number of extent sizes that are multiples of each other so that if an object is dropped or relocated the free extents created are the same size that will be requested for the next extent allocation in the tablespace. This generally means that initial = next and pctincrease = 0. Depending on how large a table/index will be on initial load and how fast it will grow you may want to set the initial extent to hold most of the object and then set the next to be one of the uniform sizes. When we ran dictionary managed we divided all our objects into one of 3 classes: small, medium, and large. The small tablespaces used several different extent sizes from 64k to 1M, the medium tablespace had only 10M extents, and the large tablespaces used only 100M extents. You should make your choices based on your object sizes and count of objects within size groupings. IMHO -- Mark D Powell -- -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Seema Singh Sent: Tuesday, March 16, 2004 2:16 AM To: oracle-l@xxxxxxxxxxxxx Subject: storage parameters what would be value of storage parameters of following tables? create table search_types ( modifier_type_key varchar2(50) not null PK , modifier_pretty_type varchar2(100) not null ); assumption: total#of rows=300 , pctfree=5 ,inittrans=1 ,pctincrease=0,pctused=40 what would be good value of INITIAL and next ? thx-seema _________________________________________________________________ Fast. Reliable. Get MSN 9 Dial-up - 3 months for the price of 1! (Limited-time Offer) http://click.atdmt.com/AVE/go/onm00200361ave/direct/01/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------