What is PCT Free and PCT Used?What is PCT increase parameter in segment?What is growth factor?

mkguduru

 Profile Answers by mkguduru Questions by mkguduru

• Jan 21st, 2010

PCTFREE: Percentage of blocks to be reserved for future updates.After this parameter is met the block is considered to be full and it is not available to insert new rows. PCTUSED: It allows the block to reconsidered for the insertion of new rows.

refakat

 Profile Answers by refakat Questions by refakat

• Aug 12th, 2009

This is the parameter which specify in percent  that a block can only used for insert or come in the freelist(list of blocks in segment ready for insert operation) when used space in a block is less ...

Answer Question  Select Best Answer