Re: Locally managed tablespaces or...

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Wed, 19 Mar 2003 21:30:05 -0000
Message-ID: <3e78e4e0_2@mk-nntp-1.news.uk.worldonline.com>

"dani" <drezustam#QUITAESTO#@airtel.net> wrote in message news:b576sa$38k$1_at_nsnmrro2-gest.nuria.telefonica-data.net...
> Hi,
> I am planning a 9.2 database, and the locally managed tablespaces are new
to
> me, 'cause I came from an 8.0.5.
> what is better: locally managed tablespaces or dictionary managed
> tablespaces??
> if so, is it good to set segment space management to auto?? works the
> bitmaps to manage free space fine?
>
> ....
>
> thanks
>
> Daniel Rezusta
>
>

FWIW: I'd go with LMT, but recommend uniform size. In a typical db (is there any such animal?), small, med and large for each class (owner?) of objects.

Others may disagree; I have no strong view on this.

Regards,
Paul Received on Wed Mar 19 2003 - 15:30:05 CST