Locally Managed Tablespaces 2005-01-20 - By Wolfgang Breitling
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
|
|
