Re: Calculating disk space requirement

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 23 Apr 2001 22:08:29 -0700
Message-ID: <3AE50A4D.825320FE@exesolutions.com>

The number of entries is only slightly relevant to the task at hand. And it sounds like you may be wholly unequipped to deal with it.

First you need the average row sizes for your table rows. Multiply that by the number of records in a table and then add a good factor for growth which will also cover overhead. Do the same thing for every index using the calculation Oracle suggests for your version. Then determine how large your SYSTEM (between 100 and 250MB), ROLLBACK, and TEMP tablespaces will be. Add to that the space for control files, log files, archived log files, and perhaps 800MB for the Oracle software itself.

Then triple it!

Daniel A. Morgan

Ram Balakrishnan wrote:

> Hello,
>
> I have a oracle schema and I want to compute disk space requirement for the
> database when there are 100000, 200000, 400000 entires. The database would
> be
> used by a online registration/modification tool. Is there any thumb rule for
> this. Also please let me know if there any tools available for computing
> this.
>
> Thanks,
>
> Ram
>
Received on Tue Apr 24 2001 - 00:08:29 CDT