harimanavalan

 Profile Answers by harimanavalan 

• Feb 25th, 2009

 

PCTFREE is a block storage it use to mention how much space should be left in database block for future updates (updating the records eg. previously name kalyan after that we will update the name as kalyan kumar). If mention PCTFREE as 10, oracle will adding the new rows to block upto 90% Its allows 10% for future updates.

m4k4v3l1

 Profile Answers by m4k4v3l1 

• Jul 1st, 2009

 

PCT Used :
Equals 100 - PCT Free , Also It states the used space in the data file by records,

If PCT used was set to 60 this means
If the data inside the block is 60, it
is FULL
If data inside the block is 59, it is Empty

refakat

 Profile Answers 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 than PCTUSED.
Suppose value of pctused is 40% and pctfree is 20% then data can be inserted till 80% of the block directly. And suppose the used space is 60% and some one has perform a delete operation in a row in the same block which brings the used space to 50%.Now one cannot insert any record in the same block unless the used space comes down below 40% i.e. pctused.

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.