random with if available statement infront
On 10/6/06, amonte <ax.mount_at_gmail.com> 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
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 06 2006 - 04:16:24 CDT
