Re: Indexed Tablespace Fragmentation

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Tue, 30 Apr 2002 21:00:46 +1000
Message-ID: <3cce7a59$0$15477$afc38c87@news.optusnet.com.au>

In article <1020117147.18578.0.nnrp-12.9e984b29_at_news.demon.co.uk>, you said (and I quote):
>
> There's a difference between
> extents per segment
> and
> extents per tablespace

yup.

>
> One reason I like to keep extents per segment
> quite low (ideally a few dozen, worst case a
> couple of hundred) is to ensure that the
> tablespace as a whole doesn't end up
> with huge number of extents.

Is that for lmt AND dmt?

-- 
Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam

Received on Tue Apr 30 2002 - 06:00:46 CDT