RE: datafiles space allocation algorithm

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

--
http://www.freelists.org/webpage/oracle-l