datafiles space allocation algorithm
- From: amonte <ax.mount@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 6 Oct 2006 10:52:56 +0200
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
Other related posts:
