Re: Locally Managed Tablespaces -- Good or Bad?

ttrivedi wrote:
>
> 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

I agree - the only thing possibly worth considering is keeping the SYSTEM tablespace as dictionary managed, because the bitmap for locally managed spaces is not cached, thus a disk trip would be required each time you need to see the dictionary.

Cheers

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse