Re: Poor mans RAID10...

Volker Hetzer wrote:
>
> Hi!
> I'm thinking of distributing one tablespace across several spindles simply by
> having one tablespace consisting of several datafiles.
>
> Does anybody know about how oracle (9i, Linux) actually allocates space
> across the different datafiles?
> Is one table always in one file or is the granularity the extent?
>
> Lots of Thanks!
> Volker

An extent is allocated in a datafile. The next extent for the table could be allocated in another datafile. But you can not be sure that this will happen.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"