How I calculate Initial, Next, PCTUSED, PCTFREE,.. and other storage parameters in the creation of a table.
row_average_size = 2400
number of rows = 90000
only 1 index (PK with 2 columns).
it has 2 columns quite big (varchar2(2500), varchar2(800))
At first, the 2 big columns will with no value.
After a process, all rows will have these fields completed.
Thanks in advance
PCTFREE parameter reserves space in blocks for future update activity . PCTUSED sets the amount of space that can be used before the block is placed on the used extends .
What you could do is to put dummy data in your 2 big rows.