Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> datafiles space allocation algorithm

datafiles space allocation algorithm

From: amonte <ax.mount_at_gmail.com>
Date: Fri, 6 Oct 2006 10:52:56 +0200
Message-ID: <85c1fb130610060152x6268d30ao43ff36e5f59a9cea@mail.gmail.com>


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-l
Received on Fri Oct 06 2006 - 03:52:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US