Re: Locally Managed Tablespaces -- Good or Bad?

Marilee Niemi wrote:

> I just installed Oracle 8.1.6, and I noticed that the default for the
> non-system tablespaces is now "Locally Managed" versus Dictionary. I
> read Oracle's propaganda on local vs. dictionary but I still do not know
> whether it is really advantageous to use locally managed tablespaces.
> This is a new database not an upgrade, so I do not have to worry about
> the difficulties in shifting from Dictionary to Local.
>
> Any real world experiences and tips would be greatly appreciated.

We here at deja just moved from Dict to local. % gain of around 12%. Worth it if you ask me. Down sides ? None so far. If I find out I will let you know.

                                                Tapan HTrivedi