Re: locally-managed tablespaces vs dictionary-managed tablespaces in 8i

I haven't yet been able to think of any serious ones.

The views dba_extents et. al. will probably suffer if you use them casually because the information will now be scattered across more physical space.

If you extend a tablespace, the bitmap for that tablespace will be scattered one piece per extension, which leaves me a little uncomfortable (for no good reason really, but I could imagine an error somehow writing across the bitmap of one section because another bitmap claimed to own the space).

Generally I think it is a very smart move for sundry reasons, and I think (with some reservations) Oracle would recommend them in many situations.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Magnus Lassi wrote in message <376f0514.550422_at_nntpserver.swip.net>...
>I've read about the locally-managed tablespaces in the manual for
>8i..there seems to be many advantages using it, however I haven't been
>able to find any disadvantages with this feature. Are there any
>situations where you would want to avoid this? I have talked to some
>people but noone seems to know for sure..are these locally-managed
>tablespaces something Oracle reccomends?
Received on Tue Jun 22 1999 - 01:39:52 CDT