Niall
> This is true for the straightforward case of one table on its own in
> its own ts but is affected by factors such as
>
> other objects also growing at the same time
> files having autoextend or not - especially if there is a mix in the
> same ts
> available 'holes' in the existing datafiles
>
> and so on.
I agree with you. I was just trying to explain from where the
"round-robin" stuff comes from... No more no less.
> In general though I can't really see why, other than curiosity,
> anyone would care about where a next extent would be allocated these
> days. (just that it would be).
One more, I completely agree. Such stuffs, i.e. spreading extents over
many files, were performed loooong time ago to spread data over many
disks. Today, usually, it makes no more sense.
Cheers,
Chris
