Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> datafiles space allocation algorithm
Hi
Suppose we have 4 datafiles in a tablespace, when we load data into this tablespace how will Oracle assign the space? I thought it would use round-robin like but it does not.
Before load I had datafiles which looked like this:
TABLESPACE_NAME
FILE_NAME BYTES ------------------------------ ------------------------------------------------ ---------- PM_IND_T01
/u02/oradata/vmw1020/PM_IND_T01_SIMP001.dbf 16
PM_IND_T01
/u02/oradata/vmw1020/PM_IND_T01_SIMP002.dbf 16
After load it shows this:
TABLESPACE_NAME
FILE_NAME BYTES ------------------------------ ------------------------------------------------------------ ---------- PM_IND_T01
/u02/oradata/vmw1020/PM_IND_T01_SIMP001.dbf 272
PM_IND_T01
/u02/oradata/vmw1020/PM_IND_T01_SIMP002.dbf 1984
How does this work?
Thanks
Alex
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 06 2006 - 03:52:56 CDT
![]() |
![]() |