Pct increase refer to the percentage by which each next extent will grow.Increases extent size is a extent size + pct increase.Its has pct use and pct free.
PCTUSE:Pctuse is a block storage parameter use to specify when oracle consider block should be empty and enough to added free list.
PCTFREE:Pct free is a block storage parameter used to specify how much space should be left in database block for further update.
SQL>select pct_free FROM user_table where table_name='EMP';
PCTUSE:Pctuse is a block storage parameter use to specify when oracle consider block should be empty and enough to added free list.
PCTFREE:Pct free is a block storage parameter used to specify how much space should be left in database block for further update.
SQL>select pct_free FROM user_table where table_name='EMP';
