RE: storage parameters

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 16 Mar 2004 09:31:48 -0500
Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0AA4C@USAHM018.amer.corp.eds.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Seema Singh Sent: Tuesday, March 16, 2004 2:16 AM
To: oracle-l_at_freelists.org
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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://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_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue Mar 16 2004 - 08:28:35 CST