We have tables with a lot of data (50M new rows each month, just in one table).
Now I want to know what would be the impact of adding a new column to those tables, or creating a new table. Something like: the new column on table X can increase the space used by 12% of its current size. Or: given that the new table is going to grow by 1000 rows/day, the expected size will be Y in one month.
I already found some information about the
DBMS_SPACE package, but it seems useless because
create_table_cost_colinfo() is returning useful information only for
Do you have any suggestion to "easily" estimate those information?