How can I prevent tablespace fragmentation?

santosh
Posts: 1311
Joined: Wed Sep 07, 2016 4:43 pm

How can I prevent tablespace fragmentation?

Postby santosh » Sat Nov 12, 2016 2:47 pm

How can I prevent tablespace fragmentation?

raoneel2016
Posts: 824
Joined: Wed Oct 05, 2016 2:40 pm

Re: How can I prevent tablespace fragmentation?

Postby raoneel2016 » Sat Nov 12, 2016 2:48 pm

Always set PCTINCREASE to 0 or 100.

Bizarre values for PCTINCREASE will contribute to fragmentation. For example if you set PCTINCREASE to 1 you will see that your extents are going to have weird and wacky sizes: 100K, 100K, 101K, 102K, etc. Such extents of bizarre size are rarely re-used in their entirety. PCTINCREASE of 0 or 100 gives you nice round extent sizes that can easily be reused. Eg. 100K, 100K, 200K, 400K, etc.


Return to “Oracle”

Who is online

Users browsing this forum: Google [Bot] and 1 guest