Re: Locally Managed Tablespaces

I do not overly worry about the number of extents either - at least not as long as I can grasp them with one look without having to divide them into groups of 3. What I do worry about is the rate at which extents get added and if you have transaction tables (as opposed to more static setup or warehouse type tables) you likely have a growth pattern which is correlated to the size (or probably more accurately vice versa). I like to size the uniform extents such that a growing table adds between 1-30 extents per month (anywhere between once a month and once a day, although the latter is already too much for my liking).

I'll have to read that ask tom link.

Niall Litchfield wrote:

>
> I guess my bias is that I really, really don't care how many extents
> my segment has (at least if I did have tens of thousands i'd be
> worrying about partitioning instead) and so I see no reason to use
> auto.
>

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l