What Is PCT Increase Setting?


2 Answers

bhushan mungase Profile
bhushan mungase answered
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';
Anonymous Profile
Anonymous answered
PCTINCREASE: It take place when two extent are already allocated.it work for third or subsequent extent. Third extent size last extent size+ pctincrease of last extent size.

Answer Question