Re: Sizing Oracle database

Here's a quick way to get you close at least for your tables..

1. Start with your db_block_size and subtract 90 bytes for block overhead to get the available space per block.
2. From the available space derived in #1, subtract (available space * pctfree) to give you the space available for row inserts.
3. Since you know your columns and datatypes you can estimate the average row length using 8 bytes for DATE fields, 4 for NUMBER columns and the actual size for VARCHAR2 columns and add it all up to get a row length in bytes.
4. Divide the space available for inserts (from #2) by row length (from #3) to get the number of rows per block.
5. Divide the number of rows you expect the table will hold by the number of rows per block (from #4 ) to get the number of blocks you expect the table to need.

That'll ballpark you to get started...at least for your tables.

Steve

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 23 2001 - 13:41:45 CDT