Hello all.
Is there someone who knows (or has doc)
how exactly Oracle decides which
datafile to extend if the tablespace
have more than one datafile.
Example :
Tablespace TS1 has 3 datafiles :
data1.dbf - 10M free
data2.dbf - 20M free
data3.dbf - 15M free

Autoextend is enabled for the datafiles.
EMP table wants to allocate next extent of 50M.

Which datafile oracle will choose to
extend and why ?

Good luck.