Minimize RECORDS_PER_BLOCK[Oracle]

Minimize RECORDS_PER_BLOCK

Alter TABLE table_name MINIMIZE/NOMINIMIZE 
RECORDS_PER_BLOCK

ALTER TABLE	Required keywords.
table_name	The unique name of the table.
MINIMIZE/NOMINIMIZE	You must use one of these keywords. NOMINIMIZE is the default.
RECORDS_PER_BLOCK	Required keywords.

Expert Oracle Indexing and Access Paths

Oracle Systems

Many Oracle systems store rows as small and then expand them with SQL UPDATE statements causing the rows to fragment into multiple blocks.
To prevent the inevitable row migration that results from extreme row size expansion, I set PCTFREE to a high value whenever rows are stored small, and later expanded.