RE: STORAGE PARAMETER COMPUTE

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Mon, 22 Mar 2004 15:34:04 -0500
Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0AA6A@USAHM018.amer.corp.eds.com>

There was a different named thread on this topic just last week. The primary answer is it depends on how much data will exist in the initial load, how much data will be added in X time, and what type of tablespace management policy is in effect: dictionary, LMT (uniform, autoallocate).

See the archives for more information

HTH -- 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: Monday, March 22, 2004 1:22 PM
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(r) 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


----------------------------------------------------------------

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 - 14:45:40 CST