Re: datafiles space allocation algorithm

random with if available statement infront

On 10/6/06, amonte <ax.mount@xxxxxxxxx> wrote: 

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




--
regards,

Sinardy

Other related posts: