Re: Poor mans RAID10...

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Mon, 15 Mar 2004 18:18:17 +0100
Message-ID: <c34ogq$kil$1@nntp.fujitsu-siemens.com>

"Holger Baer" <holger.baer_at_science-computing.de> schrieb im Newsbeitrag news:c34o0d$gjo$1_at_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 ;-)
Well, we do have RAID1 pairs, so 8 disks leave me with four places to put my datafiles into. (Okay, minus one for the redos.)

Lots of Greetings!
Volker Received on Mon Mar 15 2004 - 11:18:17 CST