PCT Increase Parameter

What is PCT increase parameter in segment?

Questions by sakshigopal

Showing Answers 1 - 1 of 1 Answers

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions