Re: Table size

"PHernandez" <phph109_at_yahoo.es> wrote in message news:1117567148.413604.234540_at_g47g2000cwa.googlegroups.com...
> Oracle 10g, Linux 386, Cooked files
>
> I need to calculate/estimate how much disk space a database will use.
> What would be best: Create the database add data, check size, add data
> and check size and use the difference to estimate how much the database
> will increase over time OR calculate how much space each row in each
> table will use and then use this data to estimate the size?
>
> If the first, about how much data do I need to load to get numbers that
> are more or less reliable? If the latter, eh, how exactly is that done?
>
> I assume that I need to sum the bytes each column uses for a row, and
> it seems that the characterset matters for chars and varchars. That
> would be the easy part. Then there is probably some overhead. And for
> the indexes I really don't have a clue. Oracle leaves space empty to
> let rows grow. What more to consider?
>
> There doesn't seem to exist documentation on how to proceed with this.
>
> Thanks for your time,
> ph
>

I would do it the first way, use volumetrics from the analysis phase to help you populate the db, build your indexes, analyze and then test, When it is acceptable in terms of performance scale the sizes upwards. Received on Tue May 31 2005 - 17:27:10 CDT