STORAGE PARAMETER COMPUTE

From: Seema Singh <oracledbam_at_hotmail.com>
Date: Mon, 22 Mar 2004 13:22:15 -0500
Message-ID: <BAY10-F26NpqhNPPzQT000095ea@hotmail.com>

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

Received on Mon Mar 22 2004 - 15:05:19 CST