RE: STORAGE PARAMETER COMPUTE

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Mon, 22 Mar 2004 19:50:37 +0100
Message-ID: <JFEEIGBIDOCCDALDIPLNMEDNCBAA.lex.de.haan@naturaljoin.nl>

Seema,

if this question is based on the desire to store the whole table in a single extent, then you should change your thinking about extent management. typically, it is preferrable to only have a limited number of different extent sizes in your database. preferrably in locally managed tablespaces, of course. in that case INITIAL becomes irrelevant; you only need to do some overall capacity planning.

hope this helps, kind regards,
Lex.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Seema Singh Sent: maandag 22 maart 2004 19:22
To: oracle-l_at_freelists.org
Subject: STORAGE PARAMETER COMPUTE

Hi,
How to compute table storage parameters INITIAL value ? Total# of rows=20,000

PCTFREE=15
PCTUSED=75
PCTFREE=0

INITRANS=1
NON-CLUSTERED TABLE. create table category_map (

        fr_category   integer not null,  (Integer 38)
        to_category     integer not null,  (integer 38)
        weight          integer not null default 5 check (weight between 1

and 10),

constraint CAT_TO_CAT_PK PRIMARY_KEY (from_category, to_category),

        foreign key     (from_category) references categories(category_id),
        foreign key     (to_category) references categories(category_id)

);

Please advice.
Thx -Seema

Thanks for your help on this.

Is your PC infected? Get a FREE online computer virus scan from McAfee® Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

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

Received on Mon Mar 22 2004 - 12:51:45 CST