Latest Answer : PCTFREE : This clause is used for future updation, If you increase PCTFREE value, There will be less rows inserted in block ...
Latest Answer : Better performance, proper use of space . ...
Latest Answer : to avoid row migration from future updates to the block pctfree is set. ...
Latest Answer : by specifying the storage clause while creating table. ...
PCTFREE parameter Row size also reduces no of rows per block.
We can plan the storage for a table as how much initial extents are required, how much can be extended next, how much % should leave free
This is used to reserve certain amount of space in a block for expansion of rows.
Limit the number of extents in the tableSeparate Table from its indexes.Allocate Sufficient temporary storage.
When Segment is dropped.When Shrink (RBS only)When truncated (TRUNCATE used with drop storage option)