Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Local managed tablespaces
There is a degree of tidiness about UNIFORM that is particularly appropriate when you have a very large database with lots of tablespaces.
However, for a relatively small database with
just a few tablespaces, AUTOALLOCATE is
a nice solution for keeping things quite tidy
without worrying too much about the detail.
The only really significant point to remember
is that AUTOALLOCATE seems to allocate
in just 3 sizes: 64K, 1MB and 8MB, so if
you have very large object you can end up
with a very large number of extents in
a single tablespace.
-- Jonathan Lewis Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk Practical Oracle 8i: Building Efficient Databases Publishers: Addison-Wesley See a first review at: http://www.ixora.com.au/resources/index.htm#practical_8i More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html Frank Black wrote in message ...Received on Mon Dec 18 2000 - 14:08:15 CST
>All,
>
>does anyone have experience with Local Managed Tablespaces. If yes, did you
>use the uniform or autoallocate
>option? What are the reasons to choose for Autoallocate or the Uniform
>option? Why use Uniform when Oracle
>can handle the exent allocation by itself?
>
>thank in advance,
>
>Hink Wiersema
>
>
>
>