Tablespace Fragmentation

How can you prevent tablespace fragmentation? (rebuilding, moving)?

Questions by arunakumaris

Showing Answers 1 - 3 of 3 Answers

vidyajnath

  • Apr 23rd, 2010
 

As rows are added to tables, the table expands into unused space within the space. Conversely, when rows are deleted, a table may coalesce extents, releasing unused space back into the tablespace. As this happens, it is possible for there to be discontiguous chunks, or fragments of unused space within the tablespace.
Tablespace fragmentation can be prevented by using PCTINCREASE command. PCTINCREASE is the percentage a new subsequent extent will grow. This value should be ideally set to 0 or 100 to avoid tablespace fragmentation. Alternate and strange values for PCTINCREASE results in strange sizes of extents. Same size of each extent of all segments must be used

  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