S. Lee

• Mar 9th, 2015

 

The percent increase in size of each subsequent extent that is added to your segment as it grows. Table test1 was created and is 4K in size. Initial size is set to 1K and pct increase set to 5. Once the first 4K is filled, oracle will add a 1K segment to extend it. when that is filled the next segment it will add is 1K * 1.05(5%) or 1.1K. Next segment will be 1.1K * 1.05 or 1.16K and so on.