Re: storage parameters
- From: "Jay Hostetter" <jhostetter@xxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Mar 2004 08:17:04 -0500
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
-----------------------------------------------------------------
Other related posts:
