Re: Poor mans RAID10...

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Mon, 15 Mar 2004 17:09:44 GMT
Message-ID: <srl5c.14531$Eg3.11861@nwrdny01.gnilink.net>

"Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message news:c34njt$fsm$1_at_nntp.fujitsu-siemens.com...
> 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

I remember imp (import) distributing the table extents over all available datafiles of the tablesapce.
Not sure if it does that in all cases..

Anurag Received on Mon Mar 15 2004 - 11:09:44 CST