Re: Poor mans RAID10...

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Mon, 15 Mar 2004 18:09:33 +0100
Message-ID: <c34o0d$gjo$1@news.BelWue.DE>

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

Hi Volker,

extents are allocated in a round robin fashion, so with several datafiles, each datafile holds about the same number of extents.

However, with regard to your subject: this is at best Raid 0 ;-)

Cheers,

Holger Received on Mon Mar 15 2004 - 11:09:33 CST