What is the use of MINEXTENTS, MAXEXTENTS and PCTINCREASE and how should one take care while setting value for these while allocating extents?

  • Interview Candidate
  • 2
  • 6563

Showing Answers 1 - 2 of 2 Answers

sanju86

  • Oct 2nd, 2008
 

All these are belong to the segment level space management.

MINEXTENTS set the number of minimum extent for any segment that to be created.

MAXEXTENTS set the number of maximum number of extent for any segment that to be allocated.

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.

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