Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Poor mans RAID10...

Re: Poor mans RAID10...

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

"Brian Peasland" <dba_at_remove_spam.peasland.com> schrieb im Newsbeitrag news:4055E487.80164F61_at_remove_spam.peasland.com...
> 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.

This is right. I whish there were a better solution but true RAID10 is out of the question.

Lots of Greetings!
Volker Received on Mon Mar 15 2004 - 11:35:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US