Re: Parallel Query Option

From: Oliver Felix Fox <off_at_Copenhagen.NCR.COM>
Date: 1997/01/31
Message-ID: <01bc0fa2$806061d0$032a4699@l174>#1/1

If your question is how to spread a tables extents to different datafiles then you can:
alter table allocate extent ... datafile ....

---

Oliver Felix Fox, International Oracle CoE NCR SE - Copenhagen
E-mail: Oliver.Fox_at_Copenhagen.ncr.com

Atul Ashar <Atul_Ashar_at_ccmail.bms.com> wrote in article <32EE3862.2EAB_at_ccmail.bms.com>...
> Hi,
>
> I need some info about spreading tables across different datafiles of a
> tablespace to reduce contention.
>
> Our tablespaces are spread across three different devices (i.e. each
> tablespace has a file on each device). I would like to spread all tables
> across all the devices so that each process of parallel query option will
 

> read different datafiles.
>
> We are using 7.3.2 on HP-9000, 4 CPUs and data are loaded using
> SQL*Loader.
>
> Any help will be appreciated,
>
> Atul Ashar
>
Received on Fri Jan 31 1997 - 00:00:00 CST