RE: storage parameters
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Mar 2004 09:31:48 -0500
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
-----------------------------------------------------------------
Other related posts:
