This partly depends on the nature of the application that will be using the data. Will it be heavily updated? Or is it read-only or read-mostly? Jared "Seema Singh" <oracledbam@xxxxxxxxxxx> Sent by: oracle-l-bounce@xxxxxxxxxxxxx 03/15/2004 11:16 PM Please respond to oracle-l To: oracle-l@xxxxxxxxxxxxx cc: 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 -----------------------------------------------------------------