Actually with LMTs the whole calculation is probably a waste of time and effort. I didn't get beyond 300 small rows = stick it in a small extent size tablespace. Specifying INITIAL and NEXT is pretty well pointless under LMTs as it merely determines how many extents you get not how large they are - the tablespace storage parameters do that. I *might* change my decision if it were 300 small rows expected to grow to 10million larger rows in the first 6 months, but from the column names this doesn't seem likely. I didn't see any discussion about the frequency of update/delete or the pattern of inserts so I can't really comment on the values chosen for PCTFREE/PCTUSED Niall Litchfield Oracle DBA Audit Commission +44 117 975 7805 > -----Original Message----- > From: jhostetter@xxxxxxxxxxxxxxxxxxxx > Sent: 16 March 2004 13:17 > To: jhostetter@xxxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx > Subject: Re: storage parameters > > > This may or may not be flawed logic, but what I would do is this: > > 150 (sum of columns) * 300 (number of records) * 1.10 (allow > 10% or so for > overhead) = 49500 or 49.5k. > > I always use multiples of the database block size. I usually > don't go below > 128k. So I would use initial and next of 128k. Then load up > the table in a > test database to see if the table grew. You don't have to > size the table > perfectly. I just use this formula to get in the ballpark. > I used to spend > the time with those formulas they had in the Oracle 7 > manuals, but with > uniform tablespaces, lots of disk space, and the debunking of > the "extent" > myth, I think it is just a waste of time. > > Jay > > >>> oracledbam@xxxxxxxxxxx 03/16/04 02:16AM >>> > 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 > ----------------------------------------------------------------- > > > > > **DISCLAIMER > This e-mail message and any files transmitted with it are > intended for the use > of the individual or entity to which they are addressed and > may contain > information that is privileged, proprietary and confidential. > If you are not > the intended recipient, you may not use, copy or disclose to > anyone the > message or any information contained in the message. If you > have received this > communication in error, please notify the sender and delete > this e-mail > message. The contents do not represent the opinion of D&E > except to the extent > that it relates to their official business. > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- > > ********************************************************************** This email contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or professional privilege. Any dissemination, distribution, copyright or use of this communication without prior permission of the sender is strictly prohibited. ********************************************************************** ---------------------------------------------------------------- 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 -----------------------------------------------------------------