Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Local managed tablespaces

Re: Local managed tablespaces

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 18 Dec 2000 20:08:15 -0000
Message-ID: <977170409.13833.1.nnrp-08.9e984b29@news.demon.co.uk>

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 ...

>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
>
>
>
>
Received on Mon Dec 18 2000 - 14:08:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US