Re: Poor mans RAID10...

From: Pedro Lopes <pedro.lopes_at_netvisao.pt>
Date: Mon, 15 Mar 2004 23:28:03 +0000
Message-ID: <newscache$ey4nuh$7ca$1@newsfront4.netvisao.pt>

Or.. if you can use 10g, you can take advantage of ASM (automatic storage managament) for free .. and it does all the mirroring and stripping stuff for you. Give it a try ;)

Pedro

NetComrade wrote:
> 1) you can use partitions, put a different partition datafile on
> different disk and hash partition the table
> 2) there has to be some freeware volume management software out there
> for linux (software raid)
>
> On Mon, 15 Mar 2004 18:02:53 +0100, "Volker Hetzer"
> <volker.hetzer_at_ieee.org> 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

>
>
> .......
> We use Oracle 8.1.7.4 on Solaris 2.7 boxes
> remove NSPAM to email
Received on Mon Mar 15 2004 - 17:28:03 CST