table design

[raju_sbd]

How I calculate Initial, Next, PCTUSED, PCTFREE,.. and other storage parameters in the creation of a table.

db_block_size= 8k
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

[ligang]

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 .

[mike9]

What you could do is to put dummy data in your 2 big rows.