Re: Setting pctincrease 0 at the tablespace level

"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3B11A9B6.9D34A58F_at_exesolutions.com...
> Niall Litchfield wrote:
>
> > comments below
> > "Dino Hsu" <dino1_at_ms1.hinet.net> wrote in message
> > news:ia02ht0iku7utfb2t6fkocr0geecrjkkig_at_4ax.com...
 <snip>
> > > 3.Do you think fixed extent size stand well most of the time?
> >

 <snip>
> >
> > It might be worth (re)reading the extended discussion about locally
 managed
> > tablespaces between Nuno and Howard, amongst others from about a month
 ago
> > on this group, this effectively outlines the considerations in some
 depth.
> > (you can use locally managed tablespaces as a method of forcing uniform
> > extent size).
> >

 <snip>
> But if you have Oracle 8i use locally managed tablespaces and you can
 forget
> the whole thing.

I agree entirely, but the discussion about why LMT's are so good (and when they might not be) illuminates the discussion for older versions of the server.

--

Niall Litchfield
Oracle DBA
Audit Commission UK