STORAGE PARAMETER COMPUTE
- From: "Seema Singh" <oracledbam@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 22 Mar 2004 13:22:15 -0500
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@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: