Re: Dictionary-managed tablespace

> The usual caveats apply: PCTINCREASE should always and without exception
be
> 0. Not 1, not 100. Zero. Every time. Based on the numbers you are
reporting,
> you've got odd-sized extents in that tablespace, and that's a recipe for
> fragmentation.

OK, but when you set PCTINCREASE to 0 then SMON doesn't coalesce free extents. So you have to do it manually, don't you ?

Regards
EP Received on Sat Jul 13 2002 - 02:55:21 CDT