Table size

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 Received on Tue May 31 2005 - 14:19:08 CDT