Re: Sizing Oracle database

If you know the number of bytes for a typical row in each table ...

For each table, size = (bytes/row * rows) * 2 (for overhead, indexes, etc)

For database: Sum all tables, add 500 MB for basic stuff For software: Add another 1 GB

Once you have that all set up, start up the Enterprise Manager Diagnostics Pack to monitor and get accurate results as well as predictions for when you will run out of space.

No matter how accurate you calculate this stuff, you will always be out - either due to changes in overhead, new (not previously anticipated) indexes, unexpected growth, etc. Be reasonably liberal if you can afford it - disk is surprisingly cheap now.

To summarize: for starter database and software, 1.5 GB minimum, then add 2x the expected size of all your tables. Use the 'character' equivalents for all columns in your tables (number 1234 = 4 bytes)

If the above calculations exceed 100 GB (which means you're getting to serious $ for disk), then go to http://technet.oracle.com and download (and read) the 'Administrators Guide' documentation that gives the exact calculations in detail.

/Hans

User wrote:

> I am newbie here.
>
> I want to find out how much disk space I'll require for
> Oracle 8i database. I know the columns and table numbers.
> How can I calculate out the disk space reqiored from that?
> Is there any site where I can find some information on this?
>
> I have searched Oracle site but couldn't find any useful
> info.
>
> -TIA.
Received on Mon Apr 30 2001 - 00:18:30 CDT