Re: Dictionary-managed tablespace

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Sat, 13 Jul 2002 18:04:27 +1000
Message-ID: <y3RX8.33999$Hj3.102708@newsfeeds.bigpond.com>

Hi,

Tag, my turn :)

If all your extents are of the same size (because you set INITIAL = NEXT and PCTINCREASE = 0) then you have *no* fragmentation (as all 'holes' left behind by dropped objects are totally reused). If you have no fragmentation, you have no need for SMON to coalesce anything (basically SMON goes on a holiday to a nice Aussie beach and has a nice relaxing break :).

PCTINCREASE = 0 is definitely the way to go and forget about SMON coalescing.

Cheers

Richard
"EP" <ep_at_plusnet.pl> wrote in message news:agom8j$7fg$1_at_news.tpi.pl...
>
> > 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 - 03:04:27 CDT