Xref: alice comp.databases.oracle.server:39600
Path: alice!news-feed.fnsi.net!oleane!news-raspail.gip.net!news-lond.gip.net!news.gsl.net!gip.net!newspeer.clara.net!news.clara.net!nnrp2.clara.net.POSTED!not-for-mail
From: "Iain McLaren" <imclaren@clara.net>
Subject: Re: Database Sizing Estimation on Designer/2000
Newsgroups: comp.databases.oracle.server
References: <78pt1a$l5h4@news.asiaonline.net>
Message-ID: <01be4ee5$7ccc6580$LocalHost@carrot>
X-Newsreader: Microsoft Internet News 4.70.1155
Lines: 26
Date: Tue, 02 Feb 1999 19:55:49 GMT
X-Complaints-To: abuse@clara.net
X-Trace: nnrp2.clara.net 917985349 195.8.78.148 (Tue, 02 Feb 1999 19:55:49 BST)
NNTP-Posting-Date: Tue, 02 Feb 1999 19:55:49 BST


Ken,

> I saw there is the repository report in helping to get the
> database sizing estimation, but I don't know where to
> input the data volume size for each table.  Appreciate
> for your help. many thanks.

You can enter the sizes via the Repository Object Navigator. Each
table definition has attributes for number of rows and max. number
of rows. Fill these in and then run the report. You also need to fill
in estimates for avg. column width for variable width columns and
percentage null for null fields (although Designer puts in default
values for these).

You can also get to the row count attributes from the Data Design
diagrams. It's on the first dialogue presented when you open up
a table description.

Cheers,

Iain.
-----
Iain McLaren
email: imclaren@clara.net
http://home.clara.net/imclaren