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

Follow-Ups:

Re: datafiles space allocation algorithm
From: Sinardy Xing

RE: datafiles space allocation algorithm
From: Mark W. Farnham

datafiles space allocation algorithm

Other related posts: