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: type of striping

Re: type of striping

From: Chuck <skilover_at_softhome.net>
Date: Tue, 07 Dec 2004 14:18:11 -0500
Message-ID: <31mdvlF3e4ud1U1@individual.net>


Frank van Bortel wrote:
> yls177 wrote:
>

>> Hi, i understand that there are different types of striping for raid 0.
>>
>> 1) OS/Hardware striping
>> 2) manual striping
>>
>> And the general consenus is that OS/Hardware striping is better than 
>> manual.
>>
>> Please advise

>
>
> Advise what?
> Against the general consensus? Which would probably be hardware
> over software, btw.
>
> How would you stripe manually?!? Get your sleeves rolled up,
> put on your high voltage protection gloves, and jump into the
> computer case?
>

By manual striping, I think he meant the old practice of manually pre-allocating extents to specific datafiles. I don't think anyone does this anymore. Back in v7 Oracle used to allocate extents in a different way than it does today. If you had multiple datafiles in a tablespace, it would fill the first datafile, then the second, etc. Now it distributes the extents evenly across all datafiles in the tablespace, effectively doing automatically what DBA's used to have to do manually. You can probably still find references to manual striping in the old v7 manuals if they are still online anywhere.

--
Chuck
Received on Tue Dec 07 2004 - 13:18:11 CST

Original text of this message

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